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
Hi
have a look at Chris O'Sullivans tool T.O.Y.S. at
http://www.impacttoys.com that allows you to extract the schema from a
database.
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by
many tools will do that, but if you're on 9i, check out dbms_metadata
package.
joe
[EMAIL PROTECTED] wrote:
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 O
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 S