Title: 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:
[EMAIL PROTECTED] on behalf of [EMAIL PROTECTED]
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:
<[EMAIL PROTECTED]
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).
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.
|
