Turn of AUTOEXTEND.

[Former Member]

Hi,

How can I change the datafile autoextend from on to off and also off to on? Can this be done while the system is up?

Currently our PSAPTEP and PSAPUNDO tablespaces are in autoextend=YES while the PSAPPDE andPSAPPDE640 have autoextend=NO.

I want to change the PSAPTEP and PSAPUNDO tablespaces to NO and the PSAPPDE andPSAPPDE640 tablespaces to YES. Please advise.

thanks,

kbas

[Former Member · Accepted solution]

Hi Bas,

Command is

alter database datafile '/u01/app/oracle/ts_32k.dbf'

AUTOEXTEND on MAXSIZE <Value1> INCREMENT_BY <Value2>;

MAXSIZE specifies the maximum size that a file can be increased to.

INCREMENT_BY specifies by how much interval value file should be extended

When AUTOEXTEND is on we should ensure that there is sufficient space in the filesystem/disk.

Turning AUTOEXTEND OFF and ON can be done online ,however it is not preferable.

If doing online ,ensure there is good backup .

Following links might help you .

http://www.oracleutilities.com/autoextend.html

http://www.dba-oracle.com/t_alter_autoextend_on.htm

Padmaja

[Former Member · Accepted solution]

thanks Padmaja. Points again for you.

[Former Member · Accepted solution]

Hi Bas,

Thanks..however points does not seem to be added yet.

Padmaja

[former_member204746]

you can also use this command:

brspace -c -u / -f dfalter

check options 3 and 4

then choooe individual datafiles from these tablespace. the rest should be easy to work with.