Skip to content
Home » Oracle Database » How to Resolve ORA-01539: tablespace is not online

How to Resolve ORA-01539: tablespace is not online

ORA-01539

Tried to offline a tablespace, but it failed with ORA-01539.

SQL> alter tablespace example offline;
alter tablespace example offline
*
ERROR at line 1:
ORA-01539: tablespace 'EXAMPLE' is not online

To figure it out what status of the tablespace currently is, we can check it by this.

SQL> select status from dba_tablespaces where tablespace_name = 'EXAMPLE';

STATUS
---------
OFFLINE

It's already OFFLINE, no need to offline it.

Leave a Reply

Your email address will not be published. Required fields are marked *