All_tables in Oracle 8 [message #56360] |
Mon, 24 March 2003 22:03 |
Rupak Basak
Messages: 9 Registered: December 2002
|
Junior Member |
|
|
Hello,
While going to find how many tables there exist whose
names start with dba_, user_, and all_, I tried to
look for some of these table names in the "all_tables" but it didn't work, why? Aren't they included in this table? If not, how does oracle manage/store them?
Regards,
/Rupak
|
|
|
|
Re: All_tables in Oracle 8 [message #56399 is a reply to message #56360] |
Wed, 26 March 2003 13:10 |
sai sreenivas jeedigunta
Messages: 370 Registered: November 2001
|
Senior Member |
|
|
hi,
All_tables will not contain all the objects u menioned above because..
all All_ 's are table
all User_ ' are Views..
and all_tables is a table that contain the list of tables of all the schema's and user_tables is a View that will contain the list of tables of a particular user..
HTH
sai
|
|
|