So turn on 10046 tracing and click on the "Scripts" tab on the RH pane of the SB. Or use the OCI Spy functionality of TOAD (I think...)
Beware that different versions of TOAD generate the scripts differently. Version 7.4 (and probably 7.5 beta) have many new options in "reverse engineering" the DDL for objects. In fact, for LMTs, I think it generates too much text, like the STORAGE clause, which I don't want. My $.02, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -----Original Message----- Sent: Wednesday, December 18, 2002 11:05 AM To: Multiple recipients of list ORACLE-L The only problem with TOAD I have is I soon forgot where information is stored to write the script by hand. It is a nice tool, I have been using it since late 96, but that's a problem with all GUIs ... Raj ______________________________________________________ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -----Original Message----- Sent: Wednesday, December 18, 2002 11:30 AM To: Multiple recipients of list ORACLE-L > From: Bob Metelsky [mailto:[EMAIL PROTECTED]] > > > Im wondering what methods people are using? > I'd like a quick way to get the ddl for say... One index > TOAD -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
