Export DataPump: ORA-39167 (Tablespace was not Found) on Tablespace Export
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.
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 \
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
A similar export job did not have any errors when exported from an Oracle10g Release1 (10.1.0.x) database.
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