Oracle-L: RE: Methods to get DDL

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Wed, 18 Dec 2002 12:15:00 -0800
Message-ID: <F001.0051D77A.20021218121500@fatcity.com>

So turn on 10046 tracing and click on the "Scripts" tab on the RH pane of the SB. Or use the OCI Spy functionality of TOAD (I think...)

Beware that different versions of TOAD generate the scripts differently. Version 7.4 (and probably 7.5 beta) have many new options in "reverse engineering" the DDL for objects. In fact, for LMTs, I think it generates too much text, like the STORAGE clause, which I don't want.

My $.02,
Rich

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

-----Original Message-----
Sent: Wednesday, December 18, 2002 11:05 AM To: Multiple recipients of list ORACLE-L

The only problem with TOAD I have is I soon forgot where information is stored to write the script by hand. It is a nice tool, I have been using it since late 96, but that's a problem with all GUIs ... Raj

Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art! -----Original Message-----
Sent: Wednesday, December 18, 2002 11:30 AM To: Multiple recipients of list ORACLE-L

> From: Bob Metelsky [mailto:bmetelsky_at_cps92.com]
>
>
> Im wondering what methods people are using?
> I'd like a quick way to get the ddl for say... One index
>

TOAD

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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 - 14:15:00 CST