Re: Free tool to generate create statement

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 13 May 2002 06:12:05 -0700
Message-ID: <aboe350lga@drn.newsguy.com>

In article <aboa82$29q1_at_imsp212.netvigator.com>, "Default" says...
>
>Where can I find free tools to generate create statements from as existing
>database?
>
>

exp userid=u/p rows=n owner=u
imp userid=u/p full=y indexfile=my_creates.sql

my_creates.sql will have your ddl.

In 9i, there is also dbms_metadata that you can use as well.

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Mon May 13 2002 - 08:12:05 CDT