on 02-19-2007 10:36 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.