Again, why NO Oracle version specified?
If on 9i DB, then use DBMS_METADATA
HTH & YMMV
HAND!
"Bob Metelsky"
<bmetelsky@cps92. To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
com> cc:
Sent by: Subject: Methods to get DDL
[EMAIL PROTECTED]
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
