you could use pretoria to clean up the indexfile generated by exp/imp
http://sourceforge.net/projects/pretoria
"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message
news:LLmdnWRzTczauePeRVn-uw_at_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 Sat Nov 19 2005 - 16:08:47 CST
