extracting schema
If you are on 9I, you can use
dbms_metadata.get_ddl. You can also use export/import without data to get schema
definition.
-----Original Message-----
From:
ml-errors@fatcity.com on behalf of A.Bahar@billing-components.com
Sent: Mon 1/19/2004 5:04 AM
To: Multiple recipients of
list ORACLE-L
Cc:
Subject: extracting
schema
Hi all ,
How can I
produce extract schema script(tables , tiggers , objects, procedures ..) from
database. Any tool , script , idea ?
Thanks
Arslan
--
Please
see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
<A.Bahar@billing-components.com
INET:
A.Bahar@billing-components.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@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).
DISCLAIMER:
This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <Avnish.Rastogi_at_providence.org
INET: Avnish.Rastogi_at_providence.org
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 Mon Jan 19 2004 - 20:34:25 CST
