EXP-00068: tablespace is offline reported while executing full export (Doc ID 1089037.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.1.0.7 [Release 10.1 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 25-Jun-2013***

Symptoms

Full export reports EXP-00068 (tablespace offline) while view DBA_TABLESPACES confirms the tablespace is ONLINE.

SQL> host exp system/****** file=d:\exp.dmp full=y

-- Export log
About to export the entire database ...
. exporting tablespace definitions
EXP-00068: tablespace TS1 is offline


-- View DBA_TABLESPACES
SQL> select TABLESPACE_NAME,STATUS
from dba_tablespaces where tablespace_name='TS1';

TABLESPACE_NAME                   STATUS
------------------------------ ---------
TS1                               ONLINE

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms