on 11-25-2008 4:07 AM
Hi,
I have a doubt.
Is it mandatory to have SYSAUX tablespace in autoextend mode?
The autoextend size is 33GB.
This is the only tablespace in autoextend mode.
If i need to change the mode, what should i do and what is the command to change it.
Regards,
Siddhartha
Hi,
First read following SAP Note
Note 872851 - Oracle Database 10g: SYSAUX Tablespace
Note 969674 - Oracle Database 10g: Default Permanent Tablespace PSAPSAUX
regards,
kaushal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
read http://oraclequirks.blogspot.com/2007/06/ora-32773-and-autoextend-onoff.html
or, just leave autoextend on but change maximum size to a smaller value:
brspace -c -u / -f dfalter
option 3
Hi Siddartha,
Changing tablespace datafile autoextend value can be done using brtools where you can set max file size value to 4GB.
Brtools -> Space management -> Alter datafile
Specify datafilename ->
Alter datafile action - Autoext
In further screen
specify maximum filesize value and continue..........
SAP recommends to use brtools for SAP database operation.
Regards,
Ganesh
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.