File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes General Computing and the fly likes Table space Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » General Computing
Bookmark "Table space" Watch "Table space" New topic

Table space

Chandra Mohan
Ranch Hand

Joined: Oct 06, 2003
Posts: 62
I want to know that how much space is occuping for a particular table in the database ...?
Thax in advance

Thanks and Regards
Chandra Mohan
Joe Ess

Joined: Oct 29, 2001
Posts: 9189

That's dependent on what database you are using. Best check with your database vendor.

[How To Ask Questions On JavaRanch]
Michael Ernest
High Plains Drifter

Joined: Oct 25, 2000
Posts: 7292

Moving to General Computing

Make visible what, without you, might perhaps never have been seen.
- Robert Bresson
Eric Pascarello

Joined: Nov 08, 2001
Posts: 15385
If you go into your server and navigate through the sub folders. Look for the file on the database it should be in two parts. I do it at the end of every month and I can not think of the file extensions off the top of my head. The file will be named after the table.
If I get time I will look up the extensions.
Randall Twede
Ranch Hand

Joined: Oct 21, 2000
Posts: 4351

I hate to say this but, your name does not comply with the Javaranch naming guidelines which can be found at
please register again with a valid name.

Visit my download page
Chandra Mohan
Ranch Hand

Joined: Oct 06, 2003
Posts: 62
From my java code, how I can find out, how much space is occupying for particular table in oracle database ...?
I agree. Here's the link:
subject: Table space
It's not a secret anymore!