Re: extracting schema

2004-01-19 Thread Joe Testa
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

Re: extracting schema

2004-01-19 Thread Pete Finnigan
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

RE: extracting schema

2004-01-19 Thread Avnish.Rastogi
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