| Number of dba*, user*, all* tables [message #56359] |
Mon, 24 March 2003 21:55  |
Rupak Basak
Messages: 9
Registered: December 2002
|
Junior Member |
|
|
Hello,
I want to know that approximately how many tables there exist whose names start with dba_, user_, and all_ ? Could anybody help me with the answer?
Regards,
/Rupak
|
|
|
|
|
|
| Re: Number of dba*, user*, all* tables [message #56368 is a reply to message #56359] |
Tue, 25 March 2003 05:22  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
mag@itloaner1_local > SHOW USER
USER is "SYS"
mag@itloaner1_local > select substr(table_name,1,4), COUNT(*) from cat
2 where table_name like ('ALL%')
3 OR TABLE_NAME LIKE ('DBA%')
4 OR TABLE_NAME LIKE ('USER%')
5 GROUP BY substr(table_name,1,4);
SUBS COUNT(*)
---- ----------
ALL_ 106
DBA_ 148
USER 126
mag@itloaner1_local >
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
