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" <Lisa.Koivu_at_efairfield.com> 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: 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).
>
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: hamcdc_at_yahoo.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 - 11:24:29 CST