Home » RDBMS Server » Server Utilities » DATAFILE SYSTEM IN STATUS SYSOFF
DATAFILE SYSTEM IN STATUS SYSOFF [message #118759] Sun, 08 May 2005 02:46 Go to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Message 74723 says:
Please, somebody could help me?
I can't open database because I have the system datafile in status SYSOFF.
What can I do? How can I change that datafile to ONLINE?
Thanks a lot

My query is when can we have the status of a file as SYSOFF. as per my knowledge status can be either "INVALID" or "AVAILABLE".

Thnx in advance.

Report message to a moderator

Re: DATAFILE SYSTEM IN STATUS SYSOFF [message #118760 is a reply to message #118759] Sun, 08 May 2005 02:52 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
See the Server Reference Guide (V$DATAFILE.STATUS):

"Type of file (system or user) and its status. Values: OFFLINE, ONLINE, SYSTEM, RECOVER, SYSOFF (an offline file from the SYSTEM tablespace)"

Best regards.

Frank

Report message to a moderator

Previous Topic: SQL*Load with default value
Next Topic: Is IMPORT & EXPORT is platform dependent?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 12 15:52:43 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.