Oracle-L: Re: Methods to get DDL

From: <Charlie_Mengler_at_HomeDepot.com>
Date: Wed, 18 Dec 2002 07:39:56 -0800
Message-ID: <F001.0051CD44.20021218073956@fatcity.com>

Again, why NO Oracle version specified?

If on 9i DB, then use DBMS_METADATA

HTH & YMMV HAND!

                                                                                                                                 
                      "Bob Metelsky"                                                                                             
                      <bmetelsky_at_cps92.        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>             
                      com>                     cc:                                                                               
                      Sent by:                 Subject:  Methods to get DDL                                                      
                      root_at_fatcity.com                                                                                           
                                                                                                                                 
                                                                                                                                 
                      12/18/2002 07:15                                                                                           
                      AM                                                                                                         
                      Please respond to                                                                                          
                      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: bmetelsky_at_cps92.com

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).






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Charlie_Mengler_at_HomeDepot.com

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:39:56 CST