cancel
Showing results for 
Search instead for 
Did you mean: 

oracle Data files eutoextent to off

Former Member
0 Kudos

We have SAP 4.7 with HP UX Oracle , i want to off autoextent property for some data files , can you please help me?

Accepted Solutions (1)

Accepted Solutions (1)

former_member227283
Active Contributor
0 Kudos

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

Use this command after login into the Oracle

SQL>alter tablespace <Tablename> datafile '<Path>\XXXX.data1' autoextend off;

Thanks

Jibin

Former Member
0 Kudos

Jibin,

did you ever try yourself what you are suggesting here?

You will find out that it won't work...

But this will work:

SQL>alter database datafile '<Path>\XXXX.data1' autoextend off;

Former Member
0 Kudos

Yes it will not work...I have typed worngly....

Thanks

Regards

Jibin.

Former Member
0 Kudos

Thank you !

Former Member
0 Kudos

Thank you !

Anil