ORA-01539 tablespace ' string ' is not online
This is an Oracle Database Server Message. This can be generated by the Oracle Database when running any Oracle program.
What is the cause of ORA-01539 from Oracle 11g ?
Failed to either make a tablespace read only or offline because it is not online. A tblespace must be online before it can become read only or offline normal.
How to deal with ORA-01539 from Oracle 11g ?
Check the status of the tablespace. Use IMMEDIATE or TEMPORARY options to force all files offline. Bring the tablespace online before making it read only.
Contacting Oracle support services ?
Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support.
Linked Error Messages
- ORA-01531 a database already open by the instance
- ORA-01532 cannot create database; instance being started elsewhere
- ORA-01533 cannot rename file ' string '; file does not belong to tablespace
- ORA-01534 rollback segment ' string ' doesn't exist
- ORA-01535 rollback segment ' string ' already exists or given name has prefix _SYSSMU
- ORA-01536 space quota exceeded for tablespace ' string '
- ORA-01537 cannot add file ' string ' - file already part of database
- ORA-01538 failed to acquire any rollback segment
- ORA-01540 tablespace ' string ' is not offline
- ORA-01541 system tablespace cannot be brought offline; shut down if necessary
- ORA-01542 tablespace ' string ' is offline, cannot allocate space in it
- ORA-01543 tablespace ' string ' already exists
- ORA-01544 cannot drop system rollback segment
- ORA-01545 rollback segment ' string ' specified not available
- ORA-01546 tablespace contains active rollback segment ' string '
- ORA-01547 warning: RECOVER succeeded but OPEN RESETLOGS would get error below