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]Oracle LazyDBA home page