Re: database oracle9i structure/schemas

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 18 Nov 2005 13:58:13 -0500
Message-ID: <LLmdnWRzTczauePeRVn-uw@comcast.com>

"RaviAlluru" <ravi.alluru_at_gmail.com> wrote in message news:1132338452.693976.80080_at_f14g2000cwb.googlegroups.com...
>
> lakshmananl wrote:
>> hello Gurus, i have a clarification. is there any scripts or tool to
>> extract only the structure and schemas without the data of an existing
>> database, and use the same for creating a new one. thanks in advance.
>
>
> Try
>
> exp schema_name/pwd_at_connect_string full=y indexfile=create_script.sql
> rows=n
>
> This will create the create_script.sql
>
> with all the ddl. You should be able to modify this script (for
> tablespaces etc) and use it to create an identical schema without the
> data.
>
> Hth
>
> Ravi
>

more like:

exp scott/tiger file=scott rows=N
imp scott/tiger file=scott full=Y indexfile=scott_dml.sql

but the all table DML is REM'd out (and not formatted very nicely)

you may want to look into the DBMS_METADATA package

++mcs Received on Fri Nov 18 2005 - 12:58:13 CST