File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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: 41600
    
  55
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?