Generate DDL from a Schema

From: nickli2000@xxxxxxxxx
Date: Thu, 20 Sep 2007 22:45:40 -0700

Hi,

I am trying to generate DDL scripts for each table, view and other
indexes under a schema. I tested using DBMS_METADATA package and its
get_ddl procedure. However, I can only output the create table (view,
indexes) statements for all the tables in a schema in one script, not
in each separation script, such as create table table_1.script, create
table table_2.script, etc.
I have hundreds of tables, views, indexes, types and other objects
under one schema. I would appreciate your advice on the issue.

Thanks in advance.

Nick Li

.

Follow-Ups:
- Re: Generate DDL from a Schema
  - From: Brian Peasland
- Re: Generate DDL from a Schema
  - From: fitzjarrell@xxxxxxx
- Re: Generate DDL from a Schema
  - From: DA Morgan
- Re: Generate DDL from a Schema
  - From: Mark D Powell

Prev by Date: Re: Doing a query with string vs bind variables.
Next by Date: Merge involving a collection
Previous by thread: Determine if a parameter has been passed
Next by thread: Re: Generate DDL from a Schema
Index(es):
- Date
- Thread

Relevant Pages

Re: WSH in VS.NET 2003?
... or will wsh xml include a ... Get the "TechNet Script Center Sample Scripts" ... Other|Useful Scripting Technologies|Saving Data in XML Format ... There is no schema for getting MS. ...
(microsoft.public.scripting.wsh)
Re: Synchronization Wizard weirdness
... Using the Oracle Enterprise Manager and Oracle Change Manager packages, ... :> I have a Test Schema in the same database as the Main schema and need to ... Wizard between the Main schema and Test schema -- obviously returned the full ... :> All seems to go well, until the script actually runs. ...
(comp.databases.oracle.tools)
Re: Generate DDL from a Schema
... I am trying to generate DDL scripts for each table, ... indexes under a schema. ... I tested using DBMS_METADATA package and its ... in each separation script, such as create table table_1.script, create ...
(comp.databases.oracle.misc)
Re: Rebuilding the system schema
... a way to rebuild the system schema to get all of the objects back in? ... this a production database? ... This was the system user- logged in as system and ran a script that ... tablespace from your archived redo logs. ...
(comp.databases.oracle.server)
Re: Data Migration
... one to compare data. ... I know the schema tool will generate change scripts ... but I don't know if it can generate data change scripts. ... > was hoping there was something out there that would script the dropping on ...
(microsoft.public.sqlserver.tools)