Database Administration (MOSC)

MOSC Banner

I would like reduce my tablespace SYSAUX by resize ORA-03297

hello,

I would like resize my sysaux tablespace.

1 - i have executed : BEGIN

DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(

AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,

USE_LAST_ARCH_TIMESTAMP => FALSE,

CONTAINER => dbms_audit_mgmt.container_current);

END;

/

2 - I am seeing that it is good.

TABLESPACE      MAXSIZE MB Allocated MB  Free MB  Used MB    EXT  %Used

-------------------- ---------- ------------ ---------- ---------- ---------- -------

SYSAUX           65536     34820   28862    5958    1287  17.11

SYSTEM           65536      1990     7    1983     3  99.67

TEMP              0     77824   11072   66752     2  85.77

UNDOTBS1            0     61440   42700   18740    187  30.50

Then i see that i may reduce my datafile SYSAUX  28862 

3 - i executed my statment :

alter database datafile '/u02/oradata/DBUR2I40/sysaux01DBUR2I40.dbf' resize 25000M;

and i have this next error :

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center