wood burning stoves
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: 9167

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 http://www.javaranch.com/name.jsp
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: http://aspose.com/file-tools
subject: Table space
It's not a secret anymore!