Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
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 The Software Craftsman this week in the Agile 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
Rancher

Joined: Mar 22, 2005
Posts: 42954
    
  73
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 ]
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'
 
Have you tried LearnNowOnline? http://www.learnnowonline.com/
 
subject: How to find the current sizes of the tables in a Database?