Exactly!

On source db
exp / file=myfile.dat owner=schema_name rows=n indexes=<n if you don't want
indexes>

On target db
imp / file=myfile.dat full=y

Richard Quintin
VTLS, Inc.
http://www.vtls.com/

-----Original Message-----
From: Ruel Rodriguez [mailto:[Email Address Removed] Thursday, October 31, 2002 1:36 PM
To: LazyDBA.com Discussion
Subject: Re: How to get the list of the tables


Use the import / export utility. Export your schemas on your current DB and
then import it to your new database.



Ruel Rodriguez
Oracle Certified Professional - Application Developer
Global Computer Associates

----- Original Message -----
From: "Deepak Gupta" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, October 31, 2002 7:54 AM
Subject: Re: How to get the list of the tables


> Sorry guys,
> I don't want thje list of tables for the schema,
> i want to create a script fro create table, with all
> it coulmn names , which i cna run to create tables on
> the new machine?
>
> Thanks

Oracle LazyDBA home page