dbms_metadata, a package that will let you pull ddl for objects out of the database in a readable format.
joe Jared Still wrote: > For those of us that are still 9i ignorant, you will need to > explain your comment about 'dbms_metadata'. > > As for 'Perl expertise', you obviously don't know much > about it. > > Jared > > On Wednesday 02 January 2002 23:55, Cyril Thankappan wrote: > >>Hi >> >>With due apologies to Perl fans and shell script >>fans, >>I have failed to understand why >>to obtain these DDLs >>the import option of "show=Y indexfile=ddl_script.sql" >>is NOT used after a export with "rows=N" >> >>Of course, 9i OCPs will swear by dbms_metadata! >> >>where will that leave our 'perl expertise'? >> -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
