cancel
Showing results for 
Search instead for 
Did you mean: 

autoextent is not working

Former Member
0 Kudos

In one of our prod system, the autoextent of tablespace doesnt work.

example: today i had to usa sapdba and add space to the datafile

/oracle/SID/sapdata5/btabi_8/btabi.data8

55

PSAPBTABI

10485760000

1280000

AVAILABLE

55

YES

9437184000

1152000

2560

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Sleep,

The datafiles can be auto extended till the max size of the datafile is reached.After that you cant autoextend the datafile.Either you create a new datafile or Alter the maximum value of the automatic extension of the datafile.But since this will effect the datafiles properties for whole table space the better option will be to create a new datafile

    • Reward suitable points if found helpful

Junaid