DBA_OBJECTS would give all the objects for all schemas.
USER_OBJECTS would give all the objects for the user's schema.

-Rachna
----- Original Message -----
From: "Farnsworth, Dave" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, October 31, 2002 7:06 AM
Subject: RE: How to get the list of the tables


>-Secondly which view to look to find out what a schema
has in it.

SELECT TABLE_NAME FROM DBA_TABLES WHERE OWNER = 'Your_Schema_Name';

Dave

-----Original Message-----
From: Deepak Gupta [mailto:[Email Address Removed] Wednesday, October 30, 2002 5:44 PM
To: LazyDBA.com Discussion
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] 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 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