Home » RDBMS Server » Server Administration » User table that indicates the tables containing data
User table that indicates the tables containing data [message #56585] Wed, 09 April 2003 23:40 Go to next message
ramesh
Messages: 123
Registered: August 2000
Senior Member
Is there a user table that will indicate the user tables which contain data in them.
I need to list out only those user tables that have data in a particular schema.

Thanks.
Ramesh

Report message to a moderator

That would be user_tables [message #56590 is a reply to message #56585] Thu, 10 April 2003 03:33 Go to previous message
Thomas G
Messages: 58
Registered: April 2003
Member
and an "select * from user_tables where num_rows > 0;" would list only those who have data.

(Had data when they were last analyzed, acually)

Report message to a moderator

Previous Topic: Database Lock Up without any traces
Next Topic: Why Im not able to build a Index > 300M on a tablespace 2000M
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:22:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.