Auto Extension of Tablespaces [message #253019] |
Sat, 21 July 2007 09:34 |
opk_pavan
Messages: 2 Registered: July 2007 Location: Bangalore
|
Junior Member |
|
|
Hi,
We have a tablespace with around 20 datafiles. Datafile#15 was configured in Autoextendable mode. But, due to some reasons, extra datafiles were added later( i.e from #16 to #20) to the Tablespace. Now if my last datafile (#20) fills up, do I need to add another datafile or my Table space uses the datafile #15 which was configured to be Auto Extendable..?
Thanks in Advance,
Pavan
|
|
|
|
Re: Auto Extension of Tablespaces [message #253091 is a reply to message #253026] |
Sun, 22 July 2007 06:15 |
opk_pavan
Messages: 2 Registered: July 2007 Location: Bangalore
|
Junior Member |
|
|
Hi Michel,
Sorry I could not understand what you meant by "YES". You mean that the Tablespace will continue to extend as per Auto Extension setting of the datafile #15 ?
Please correct me if I am wrong..
Regards,
Pavan O
|
|
|
|