Re: Generate Create Table Script

From: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 24 Oct 2000 18:40:58 +1000
Message-ID: <39f53d5d$1@news.iprimus.com.au>

Try a full export, then a full import

And when you do the import, select to display the contents of the dump file only. Spool that out to a text file, and Lo! You have your script.

Regards
HJR "K.L OOI" <ooiklnews_at_yahoo.com> wrote in message news:20001024053821.4073.qmail_at_web9210.mail.yahoo.com...
> 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
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf! It's FREE.
> http://im.yahoo.com/
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 24 2000 - 03:40:58 CDT