Home » RDBMS Server » Server Administration » Want To tablespace Autoextend OFF? (oracle 11.2.0.1 RAC of two nodes,solaris10)
Want To tablespace Autoextend OFF? [message #556747] Wed, 06 June 2012 06:59 Go to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
hi,
i want to OFF tablspace AUTOEXTEND on a prodution system, we have many RAC databses and that will be done on all stations. i have got a document from net which was written on 29-Jun-2007 and it says that if need to OFF the AUTOEXTEND of a TABLESPACE so you need to ist make it off on the underlying datafiles of that tablespace so this doc is for Oracle 8.1.7.2.0 so kindly guide me is the same has to be done for my DB 11.2.0.1 and any other suggestion and guide lines on this procedure.


pleas guide

Regards


Re: Want To tablespace Autoextend OFF? [message #556750 is a reply to message #556747] Wed, 06 June 2012 07:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
if need to OFF the AUTOEXTEND of a TABLESPACE so you need to ist make it off on the underlying datafiles of that tablespace


Correct.
See ALTER DATABASE DATAFILE command in Database SQL Reference.

Regards
Michel
Re: Want To tablespace Autoextend OFF? [message #556755 is a reply to message #556750] Wed, 06 June 2012 07:28 Go to previous message
janakors
Messages: 232
Registered: September 2009
Senior Member
Thanks Michel, you are always there Smile
Previous Topic: database cant be started
Next Topic: Lock output
Goto Forum:
  


Current Time: Fri Nov 29 02:34:25 CST 2024