Home » RDBMS Server » Server Administration » System tablespace full
System tablespace full [message #58692] Fri, 26 September 2003 00:02 Go to next message
Taran
Messages: 21
Registered: December 2001
Junior Member
Hi we r using oracle9i..When we run procedure that populates too many rows.,The system tablespace gets full after 1 hour and there is no space in hard drive, the we tried to see the table ,it has no rows.So where the all space gone,How to recover that space..Kindly reply soon..

Report message to a moderator

Re: System tablespace full [message #58697 is a reply to message #58692] Fri, 26 September 2003 03:36 Go to previous message
Vikas Gupta
Messages: 115
Registered: February 2002
Senior Member
Most probably the USER has Oracle System Tablespace defined as temporary or default. Change that.

Regards,

Vikas.

Report message to a moderator

Previous Topic: How do to drop loggin ?
Next Topic: BITAND
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 15:35:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.