You can also use TOAD to generate the DDL script. Once TOAD has been
installed, the DDL script can be generated by selecting the
Database->Exports->Table scripts option, and following the instructions. A
shareware version of TOAD can be downloaded from
http://www.toadsoft.com/lic_agree.html.

Regards

Carl Scotson
DBA - Scottish Water









"Richard Quintin" <[Email Address Removed] on 31/10/2002 16:04:17

To: "LazyDBA.com Discussion" <[Email Address Removed] RE: How to get the list of the tables


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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html







Privileged/Confidential information may be contained in this Email and any files transmitted with it. If you are not the intended recipient you should not retain, copy or use this Email for any purpose or disclose all or part of its contents to any person. If you have received this Email in error please notify the postmaster and sender immediately and delete this Email from your system.

Opinions, conclusions and other information in this message that do not relate to the official business of Scottish Water ("SW") shall be understood as neither given nor endorsed by it. The contents of Emails sent and received by SW are monitored.

WARNING: Although SW has taken reasonable precautions to ensure no viruses or other malicious software are present, SW cannot accept responsibility for any loss or damage arising from the use of this Email or attachments however caused. The recipient should therefore check this Email and any attachments for the presence of viruses or other malicious software.

Scottish Water
www.scottishwater.co.uk
[Email Address Removed]Oracle LazyDBA home page