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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Engineering » General Computing
Bookmark "Table space" Watch "Table space" New topic
Author

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
Regards
Mohan.M


Thanks and Regards
Chandra Mohan
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 8836
    
    7

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


"blabbing like a narcissistic fool with a superiority complex" ~ N.A.
[How To Ask Questions On JavaRanch]
Michael Ernest
High Plains Drifter
Sheriff

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
author
Rancher

Joined: Nov 08, 2001
Posts: 15376
    
    6
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.
Eric
Randall Twede
Ranch Hand

Joined: Oct 21, 2000
Posts: 4340
    
    2

Mohan,
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.


SCJP
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 ...?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Table space
 
Similar Threads
WA #1.....word association
SDO_RDF_TRIPLE_S is a invalid datatype?
no rights in create table
creating virtual tables
Space not releasing on toggle of divs