Two Laptop Bag*
The moose likes Oracle/OAS and the fly likes How to find the current sizes of the tables in a Database? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "How to find the current sizes of the tables in a Database?" Watch "How to find the current sizes of the tables in a Database?" New topic
Author

How to find the current sizes of the tables in a Database?

Priya dharshini
Ranch Hand

Joined: Aug 06, 2005
Posts: 78
Hi,
How to find the current sizes of the tables in a Database. Please any one help me out.


Thanks & Regards,
Priyadharshini . T
Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
checkout Dan Morgans Library page from Puget sound Oracle Users Group on tables:
http://www.psoug.org/reference/tables.html

check out the two queries at the bottom of the page. Excellent resource
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41052
    
  43
Do you mean the number of rows, or something that is measured in KB/MB/GB? If the former, "select count(*) from table" will tell you that.
[ September 27, 2007: Message edited by: Ulf Dittmer ]

Ping & DNS - my free Android networking tools app
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
If you want to know the number of rows in a table:

SELECT num_rows
FROM all_tables
WHERE table_name = 'YOUR_TABLE_NAME'
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to find the current sizes of the tables in a Database?
 
Similar Threads
names and properties of tables in database using jdbc
Increasing performance through indexing
tables and fields
Listing out tables in a database
Database Tables