HELP! out of space in System tablespace

From: Bob <meyer_b_at_my-deja.com>
Date: Thu, 30 Sep 1999 19:58:23 GMT
Message-ID: <7t0fcm$ht0$1@nnrp1.deja.com>

I could really use some sage advice on this one. I'm not really a DBA, but I'm being asked to help solve a problem on a system that doesn't really have any DBA. The person who set up their databases knew just enough to be dangerous, I'm afraid, and now she's gone anyway.

The application programmer trying to log in with a user-id that has DBA priveleges. When he does, he gets the following error messages:

Enter user-name: xxxxxxxx
Enter password:
ERROR:

ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS.AUD$ by 12137 in tablespace SYSTEM
ORA-02002: error while writing to audit trail
ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS.AUD$ by 12137 in tablespace SYSTEM

OK, this tells me the System tablespace is full, I think. I can read the documentation, and it appears I need to add a new datafile to that tablespace. But to do that, I need to log in as a DBA, right? And I can't log in as a DBA without getting the error message. Sounds like Catch-22.

I get the same error messages trying to log into SVRMGR, too.

Is there any solution to this paradox?

Thanks much,

--
Bob M.

Step outside. The graphics are AMAZING!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 30 1999 - 14:58:23 CDT