| ib |
Posted: Aug 31, 2007 05:22:20 AM |
Total Post: 15
Joined: Aug, 2007
|
hi,
i want know the individual column size,table size in my database.i have to calculate all things and i have create one tablespace with the calculated size.pls very urgent any body tell me |
|
|
 meraj |
| Posted: Aug 31, 2007 06:20:39 AM |  |
|
Total Post: 27
Joined: Sep, 2006
|
Hi,
For this you will have to first calculate the row size and then accordingly estimate the size of the Tablespace.
please let me know if i m wrong.
|
|
|
|
|
| ib |
| Posted: Aug 31, 2007 06:34:17 AM | |
|
Total Post: 15
Joined: Aug, 2007
|
how to calcuate a row size pls tell me
|
|
|
|
|
| rahul |
| Posted: Aug 31, 2007 07:27:36 AM | |
|
Total Post: 16
Joined: Feb, 2007
|
When you create any table , according to fields count the every coloumn bytes and sum these bytes then you easily get the size of table .
then you can create tablespace .
|
|
|
|
|
| ib |
| Posted: Sep 01, 2007 12:13:08 AM | |
|
Total Post: 15
Joined: Aug, 2007
|
can u explain step by step with query
|
|
|
|
|
| Mohammed Taj |
| Posted: Sep 01, 2007 01:16:11 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
Hi,
for table size calculation
http://dbataj.blogspot.com/2007/01/table-size.html
for tablespace size
http://dbataj.blogspot.com/2006/11/tablespace-size_2309.html
Regards
Taj
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
