Re: Methods to get DDL

From: <Simon.Anderson_at_scisys.co.uk>
Date: Wed, 18 Dec 2002 07:55:28 -0800
Message-ID: <F001.0051CE40.20021218075528@fatcity.com>

There are scripts out there that will do the job, though most of them start to fall down if the indexes are at all unusual.

I bought a book a couple of years ago with a whole selection of scripts to create ddl for database objects - It should still be available on Amazon.

Cheers
Simon Anderson

Please respond to ORACLE-L_at_fatcity.com

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:
  INET: Simon.Anderson_at_scisys.co.uk

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: ListGuru_at_fatcity.com (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). Received on Wed Dec 18 2002 - 09:55:28 CST