Home » Other » General » Data Inventory of all tables in a database (Oracle 10g)
Data Inventory of all tables in a database [message #454641] Thu, 06 May 2010 12:11 Go to next message
lokimisc
Messages: 72
Registered: February 2008
Member
Hi,
we are doing analysis of existing database ( Oracle 10g) and I want to prepare a data inventory of all the tables in a database i.e

1. Total number of records in a table
2. Total number of records having null values in a column
3. Total number of standalone tables i.e tables that don't have any relationship with other tables
etc...

Please let me know if there are any tools or query that can do this tasks.

Thanks & Regards,
Lokesh
Re: Data Inventory of all tables in a database [message #454644 is a reply to message #454641] Thu, 06 May 2010 12:43 Go to previous messageGo to next message
Michel Cadot
Messages: 60065
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, you can use Oracle catalog for this.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_part.htm#i125539

Regards
Michel
Re: Data Inventory of all tables in a database [message #454686 is a reply to message #454641] Thu, 06 May 2010 21:37 Go to previous message
Kevin Meade
Messages: 1970
Registered: December 1999
Location: Connecticut USA
Senior Member
I am curious. In what ways to you feel this inventory will be valuable to you? If you could provide some specific examples of how you are going to use this information to good effect, that would be great.

Kevin
Previous Topic: Archiving mode issue
Next Topic: memory high (no of httpd connections increase)
Goto Forum:
  


Current Time: Mon Dec 29 05:04:25 CST 2014

Total time taken to generate the page: 0.09721 seconds