How to make AUTOEXTEND for a Tablespace OFF

[Former Member]

Hi,

In one of my Quality system in all the tablespaces(except SYSTEM,PSAPTEMP) AUTOEXTEND is ON.

But I want this to be OFF.

SO can anyone tell me exact steps to do the same?

Do I need to make each and every datafile's AUTOEXTEND OFF???

SAP 4.6C

Windows server 2003.

Oracle 9i.

Regds,

Mofizur

[stefan_koehler · Accepted solution]

Hello,

>> Do I need to make each and every datafile's AUTOEXTEND OFF???

Yes, you have to...

You can use this script - all datafiles are changed to "autoextend off".

>spool run.sql

>select 'alter database datafile '||file_name||' '||' autoextend off;' from dba_data_files;

>@run

Regards

Stefan

[Former Member · Accepted solution]

Hello Stefan,

Thanks a lot.

It worked.

Regds,

Mofizur

[Former Member]

>

>>>> But I want this to be OFF.

but why?

do you really have too much time, that you can spend it in extending datafiles manually?

Peter

[Former Member]

Hello Peter,

Actually there is some space issue in that server.

Thanks a lot for your valuable input.

Regds,

Mofizur