-
Can someone tell me if theres a sql command that I can run that will tell me exactly how many tables are in my database?
Thanks
-
SELECT COUNT(*) FROM DBA_TABLES;
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Thanks
is there another sql command that can tell me if the table is emtpy or not??
Thanks you guys are great I've learned a lot over the past month
Tim
-
Hi Please Issue this
exec dbms_utility.analyze_schema('yourschemaname','compute');
Then
Select count(*) from dba_tables
where row_num = 0;
Thanks..
-
-
[QUOTE][i]Originally posted by Oracledba8 [/i]
[B]Hi Please Issue this
exec dbms_utility.analyze_schema('yourschemaname','compute');
Then
Select count(*) from dba_tables
where row_num = 0;
Thanks..
[/B][/QUOTE]
Opps, it should be num_rows.
Take care
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|