Hi
I came across this FREE tool some months ago. It's called DataBee, and will
take an export file, load it and generate DDL scripts from it (Plus other
stuff too). The only snag is that the export file MUST have been created
using the ROWS=N option (No data). It can be downloaded from
http://www.cool-tools.co.uk/Products/dbatool.htm
Hope this helps
Carl Scotson
DBA - Scottish Water
"Vittal" <[Email Address Removed] on 31/10/2002 04:55:38
To: "LazyDBA.com Discussion" <[Email Address Removed] Re: How to get the list of the tables
Hi
I would suggest just take an export of the schema which you are intrested
and import the same in your new machine
vittal
----- Original Message -----
From: "Deepak Gupta" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, October 31, 2002 5:14 AM
Subject: How to get the list of the tables
> I am moving the datsabase from one machine to other
>
> I want to create a sql which I can run to create
> tables on the new machine with all the table name and
> the columns in it.
>
> Secondly which view to look to find out what a schema
> has in it.
>
>
> Please let meknow urgently.
>
> Thanks
>
> Deepak
>
>
> __________________________________________________
> Do you Yahoo!?
> HotJobs - Search new jobs daily now
> http://hotjobs.yahoo.com/
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit 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
DISCLAIMER
---------------------------------------------------------------------------
This email message and any attachments is confidential and intended only
for
the use of an individual or entity named above and may contain information
that is privileged, confidential or exempt from disclosure under
applicable
law. If you are not the intended recipient, you are notified that any
dissemination, distribution or copying of this email is strictly
prohibited.
If you have received this email in error, please notify us immediately by
return email or [Email Address Removed] and destroy the original message.
Opinions, conclusions, and other information in this message that do not
relate to the official business of SPAN, shall be understood to be neither
given nor endorsed by SPAN
________________________________________
Mails are Scanned and Filtered for Virus
[Email Address Removed] 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