Scenario:
SYSAUX tablespace is full.
Version:
Oracle 11.2.0.4
OS:
Windows
Solution:
There are 2 solutions:
1. Alter/increase the size of SYSAUX tablespace
2. Cleanup SYSAUX tablespace
Example:
Here is the example to alter/increase the size of SYSAUX tablespace (with autoextend and maximum size of the file to be 8GB):
(Please note that file_id here used is 2 for SYSAUX tablespace. Please verify the file_id for SYSAUX tablespace in DBA_DATA_FILES table before running this command)
alter database datafile 2 autoextend on next 10M maxsize 8G;
Oracle documentation on Changing Datafile Size:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/dfiles003.htm#ADMIN11423
No comments:
Post a Comment