I couldn't shrink my 500MB SYSTEM tablespace. Only 100MB is actually is in use.
I don't have enough reference material for this. Could I shrink/resize my SYSTEM tablespace.
Printable View
I couldn't shrink my 500MB SYSTEM tablespace. Only 100MB is actually is in use.
I don't have enough reference material for this. Could I shrink/resize my SYSTEM tablespace.
No
You can't shrink.
Hello
Did you try doing it through DBA studio or something ??
regards
Hrishy
You can shrink segments in the SYSTEM tablespace. You can even shrink the SYSTEM rollback segment (but only if the DB is started in exclusive mode).