| Tables [message #62410] |
Tue, 20 July 2004 20:49  |
Sam
Messages: 255
Registered: April 2000
|
Senior Member |
|
|
hi can anyone tell me the diff between the following queries and what they are returning, just confused.
SQL> SELECT COUNT(*) FROM DICT;
COUNT(*)
----------
788
SQL> SELECT COUNT(*) FROM DBA_TABLES;
COUNT(*)
----------
6725
SQL> SELECT COUNT(*) FROM DBA_OBJECTS WHERE OBJECT_TYPE='TABLE';
COUNT(*)
----------
6728
SQL> SELECT COUNT(*) FROM ALL_TABLES;
COUNT(*)
----------
6725
Thanx in advance
Sam.
|
|
|
|
| Re: Tables [message #62425 is a reply to message #62410] |
Wed, 21 July 2004 05:54  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi Sam,
These views are clearly described in the Oracle Server Reference Guide. Please look it up.
Here is a quick summary:
DICT/DICTIONARY - contains descriptions of data dictionary tables and views.
DBA_TABLES - describes all relational tables in the database.
DBA_OBJECTS - describes all objects in the database.
ALL_TABLES - describes all relational tables accessible to the current user.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
