Re: How do I script object creation?

OEM and similar tools allow you to show ddl and keep it to a file. There are also scripts floating about that do it, like in the faq http://www.orafaq.com/scripts/index.htm#GENSQL . If you have metalink access (highly recommended), see
https://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=131704.1

Also look at the show=Y and indexfile commands for imp in the utilities manual.

jg

--
@home.com is bogus.
Damn the torpedos!  Full speed ahead!
http://www.signonsandiego.com/uniontrib/20051109/news_1b9blockbust.html