TOAD has a 'Generate Schema script' function and if I recall correctly
you can specify the objects that you want the script to include. You can
download an evaluation copy at
http://www.quest.com/solutions/download.asp
On Tue, 2003-12-30 at 19:24, system manager wrote:
Dear all, I have a
run the same script for every table for the schema owner and spool everything to the
same file ... there you have it.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
dba_constraint will inform you of the tables that have constraints and
what type of constraint they are.
Further digging into the dba_ tables will provide the information you
desire. Keep the scripts as part of the database documentation and
update when needed.
Third party software can provide
If you have one to generate the constraints for a table, just modify
it slightly to include a whole schema.
Just checked, I don't have such a beastie.
Check orafaq.com, likely there is one there.
Jared
system manager [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/30/2003 11:24 AM
For 9i DBs, DBMS_METADATA will (re)create DDL for every (at least most)
object in the DB.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California--
Yep, that's a good call, although there was some bug with paritioned tables
I think...
Also, metalink note 1016836.6 has a script for capturing constraints.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 30, 2003 11:49 PM