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: 101
Registered: February 2008
Senior 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: 68624
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: 2103
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: Thu Mar 28 05:40:15 CDT 2024