Database Administration (MOSC)

MOSC Banner

SYSAUX Resize Issue

edited Sep 22, 2009 5:23AM in Database Administration (MOSC) 6 commentsAnswered
I have 11g on a test box with a one tablespace sysaux size of 32gb. I want to resize down to 400mb. I'm receiving the following message from EM... ora-03297: file contains used data beyond requested resize value.

 What are my options to decrease the sysaux size? Thanks, b

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