SQL & PL/SQL

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!

SYSTEM tablespace 95% full

394354Jun 18 2003 — edited Jun 20 2003

Hi,
I'm a newbie on DBA tasks. We're using Oracle 8.1.5.
I ran a script that didn't specify the temporary tablespace for a user should be TEMP, so the default temp tablespace is the SYSTEM. I ran this command to point to the correct temporary tablepace:

alter user username
default tablespace ABC
temporary tablespace TEMP
quota 0 on SYSTEM;

The problem now is how to decrease the SYSTEM tablespace (do you call this threshold?), because it's 95% full. I might not be using the right words, but my concern is that the SYSTEM is 95% full.
Please tell me the steps I should do to solve this.

Any help would be very appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 18 2003

Added on Jun 18 2003

4 comments

367 views