Autoextend Tablespace [message #71112] |
Tue, 10 September 2002 23:11 |
Amit I
Messages: 5 Registered: August 2002
|
Junior Member |
|
|
Need to get the concept cleared !
Example: Assume we have a tablespace ts1 that has autoextend set to true ! There is only 1 datafile set to ts1 !
Is it that when the datafile is full, the size of the datafile will increase (bcos of autoextend) and this will continue to happen till the disk is not full ?
And thus we can have 1 datafile for 1 tablespace and there will be no need to create any more datafiles for this tablespace ?
Ofcourse its true - for administration and optimisation related issues we might go for multiple datafiles.
Kindly comment !
Regards,
Amit
|
|
|
Re: Autoextend Tablespace [message #71116 is a reply to message #71112] |
Wed, 11 September 2002 00:18 |
sunil bhola
Messages: 58 Registered: July 2002
|
Member |
|
|
yes you are right absolutely right, you can add about 1022 file in a single tablespace for version 8.
if you have multiple files and the tablespace has autoextend option is true then all the files can get the space up to the hard disk limit.
Thanks
Keep in Touch.
|
|
|
|