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
Printable View
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;
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..
Thanks Jmodic
Opps, it should be num_rows.Quote:
Originally posted by Oracledba8
Hi Please Issue this
exec dbms_utility.analyze_schema('yourschemaname','compute');
Then
Select count(*) from dba_tables
where row_num = 0;
Thanks..
Take care