please tell me how to set the AUTO EXTENDED MODE in db02

[Former Member]

Hi

experts

can u tell me how to change the AUTO EXTENDED MODE IN

db02 ( can we change this)

[Former Member]

Hello Rajendra

Step - 1 - connect to the oracle - sqlplus "/as sysdba"

Step - 2 - select file_name,AUTOEXTENSIBLE from dba_data_files

Step - 3 - if AUTOEXTENSIBLE is on the you have to run a qurey

alter database datafile ' path of the datafile ' AUTOEXTEND OFF;

Or else

alter database datafile ' path of the datafile ' AUTOEXTEND ON;

after that Run T-Code - DB02

click on refresh tab and then click on perform database checks

wait till the action complete after that you are able to see what to want i.e AUTOEXTEND OFF or AUTOEXTEND ON

Thanks

Shishir

[stefan_koehler]

Hi Rajendra,

please use the BR*Tools for that.

Docu: http://help.sap.com/saphelp_nw04/helpdata/EN/f1/5e863f06593a17e10000000a114084/content.htm

Regards

Stefan

[Former Member]

you can do it from cmd if you know exactly which tablespace/datafile you want to set the auto extension on for.

it goes sth like this.

sql>alter database datafile"<path of the datafile>" autoextend on;

you can also find the tablespaces which are set on/off at the moment. just explore a bit on google.