Home » RDBMS Server » Server Administration » Auto Extension of Tablespaces
Auto Extension of Tablespaces [message #253019] Sat, 21 July 2007 09:34 Go to next message
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 #253026 is a reply to message #253019] Sat, 21 July 2007 10:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes.

Regards
Michel
Re: Auto Extension of Tablespaces [message #253091 is a reply to message #253026] Sun, 22 July 2007 06:15 Go to previous messageGo to next message
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
Re: Auto Extension of Tablespaces [message #253092 is a reply to message #253091] Sun, 22 July 2007 06:25 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes. Smile

Autoextensible files will continue to grow when needed.

Regards
Michel
Previous Topic: how to clone oracle10g database
Next Topic: Test and development environment Oracle AS
Goto Forum:
  


Current Time: Tue Dec 03 05:43:50 CST 2024