Re: Create Table Script

hi kian,

you might want to have a look at the EXPort utility of oracle. EXPort creates a dump file for specified table(s) in a schema, all the objects in a schema or for a full database. in your situation you could use exp to export your schema to dump file and IMPort the file at the destination source.

otherwise there are some third party tools that help you creat these scripts. TOAD being one of them. a freeware and evaluation copy of toad could be downloaded from www.toadsoft.com.

HTH, ATTA In article <8t2mob$so$1_at_nnrp1.deja.com>,   Kian Lee <ooiklnews_at_yahoo.com> wrote:
> How to generate a crete table script from Oracle?
> Right now I have more than 100 tables that need to be prepare in
 script
> method for distribute to client. And those tables were created from
> developer since the development, so I have to consolidate them.
> Therefore is there a easy way to generate a create table script
> including the constraints as well?
>
> For example, in DB2 there is a command db2look.
>
> Thanks in advance.
>
> Regards,
> Kian Lee
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--

getting the meanin' of data...


Sent via Deja.com http://www.deja.com/
Before you buy.