Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SYSAUX resize

Beauty_and_dBestSep 21 2020 — edited Sep 23 2020

12c

OL6

Hi ALL,

We have SYSAUX tablespace of size 100Gb, but only used space is 15Gb.

I want to freeup the 80Gb.

I tried to resize it using > alter database datafile 'xxxx' resize 20Gb;

But I always hit error >high watermark.

Please help...

Kind regards,

Added on Sep 21 2020

#general-database-discussions

12 comments

4,383 views