Any non-totally-up-to-date tool will typically struggle to get *all* of the ddl. A good example would be in 9i where the table compression flag has unfortunately been left off the dba_tables view. The info is of course there (tucked away in seg$) but you're setting yourself up for a lot of work if you head down into those levels..
Similarly, if you wanted a constraint which was based on an index with different columns. Obviously you need to create the index before the constraint. Pre-9 you have to go hacking around cdef$... ugh! I'd stick with "exp rows=n" hth connor --- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: > Bob, TOAD (freeware version) will do it for you > also. However, as far as > scheduling something to run regularly, exp rows=n is > the easiest. > > Lisa Koivu > Oracle Datablackeye Administrator > Fairfield Resorts, Inc. > 5259 Coconut Creek Parkway > Ft. Lauderdale, FL, USA 33063 > > > > > -----Original Message----- > Sent: Wednesday, December 18, 2002 10:16 AM > To: Multiple recipients of list ORACLE-L > > > I finally have a bit of time and was wondering what > are different > methods to get DDL other than > Export rows=n > Using Quest SQL navigator > Using The Databee tool > > Ideally Id like to get it from a sql plus command > but Im pretty sure > that's not available. DDL dosnt seem to be available > from DBA studio > either... > > > Im wondering what methods people are using? > I'd like a quick way to get the ddl for say... One > index > > Thanks in advance > bob > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Bob Metelsky > 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). > ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
