Deepak,
Let us know it just shifting of a database from one m/c to another m/c because of some h/w enhancement or some thing else.
If the situation is as i said then there is no need of generating sql and all other. Just clone the database with very less efforts.
Thanks & Regards,
Vipin Jain
Good Judgment Comes From Experience. Experiences Comes From Bad Judgment
-----Original Message-----
From: Stan [SMTP:[Email Address Removed] Thursday, October 31, 2002 10:07 AM
To: LazyDBA.com Discussion
Subject: Re: How to get the list of the tables
Deepak Gupta wrote:
>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] 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
>
>
Deepak,
If you don't want the data to be imported into another database then,
export/import with rows=N is what you need.
objects owned by any user can be found in all_objects and user_objects
for specific user.
--
hope this helps.
Stan
--------
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
Oracle LazyDBA home page