Export DataPump: ORA-39167 (Tablespace was not Found) on Tablespace Export (Doc ID 342346.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Personal Edition - Version: 10.2.0.1 to 10.2.0.2 - Release: 10.2 to 10.2
Oracle Server - Standard Edition - Version: 10.2.0.1 to 10.2.0.2   [Release: 10.2 to 10.2]
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.2   [Release: 10.2 to 10.2]
Enterprise Manager for RDBMS - Version: 10.2.0.1 to 10.2.0.2   [Release: 10.2 to 10.2]
Information in this document applies to any platform.

Symptoms

You run an Export Data Pump job in tablespace mode, with the 10.2.0.x Export Data Pump utility:

%expdp system/manager DIRECTORY=my_dir DUMPFILE=expdp_t.dmp \
LOGFILE=expdp_t.log TABLESPACES=testdat,testind

Although the tables are exported, the export job reports an error:

Export: Release 10.2.0.1.0 - Production on Friday, 25 November, 2005 9:19:45
...
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
. . exported "SYSTEM"."TESTTAB"                              0 KB       0 rows
ORA-39167: Tablespace TESTIND was not found.
Master table "SYSTEM"."SYS_EXPORT_TABLESPACE_01" successfully loaded/unloaded

Changes

A similar export job did not have any errors when exported from an Oracle10g Release1 (10.1.0.x) database.

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