Home » RDBMS Server » Server Administration » system tablespace may be corrupeted HELP!!!
system tablespace may be corrupeted HELP!!! [message #56967] Fri, 09 May 2003 10:39 Go to next message
Maria
Messages: 57
Registered: August 1999
Member
Hi all,

I found on my alert.log file the followign error:
ORA-1652: unable to extend temp segment by 3596 in tablespace SYSTEM

At that time I was runing a CTAS which creates indexes, copy tables etc, from a dblink, I don't have any user assing to the system tablespace or system temp tablespace. All my database users which they are only 2 have their own tablespace's for temps and default's. Can someone please help me with this, I'm getting scared, I have to do a CTAS again this weekend

Thanks a million
Maria

Report message to a moderator

Re: system tablespace may be corrupeted HELP!!! [message #56968 is a reply to message #56967] Fri, 09 May 2003 10:55 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
first, Add more datafiles to the system tablespace.
continue your work
later we can investigate the "temp segment in system tablespace'

Report message to a moderator

Previous Topic: to configure the database in different language
Next Topic: 9iAS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 30 17:23:45 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.