Re: Creating DDL from EXPORT

In article <40vfu4$bin_at_newsbf02.news.aol.com>, shamooli_at_aol.com says...
>
>How can I create a script of defininition of all the tables (including
>storage parameters, constraints) in a schema using EXP.
>
>We are using Oracle 7 under OS/2 2.1.
>
>Thanks for any help.

Do a full export then using IMP set the 'ROWS' parameter to 'N', or answer 'N' when IMP asks 'Import table data (Y/N): Y>'. Note, that the utilities manual says that Grants and Indexes will be created. Also, if you want the original storage parameters, then don't compress extents when you do the export. This should give you most of what you want, although the result may need some cleaning up with an editor if you plan on using to recreate the same schema somewhere else.

TN
cz0763%zip02_at_mt.gov Received on Fri Aug 18 1995 - 00:00:00 CEST