TTS Import Fails With ORA-29344 (Doc ID 1340187.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.1.0.5 - Release: 10.1 to 10.1
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.1.0.5   [Release: 10.1 to 10.1]
Information in this document applies to any platform.

Symptoms

You perform a Transportable TableSpace (TTS) import. This fails with error:

ORA-29344: Owner validation failed - failed to match owner <oenername>'

Let's follow the next example to demonstrate this:

-- create a tablespace
connect / as sysdba
create tablespace tts001 datafile '/tmp/tts001.dbf' size 10m;

-- create 2 users
create user tts001 identified by tts001 default tablespace tts001 temporary tablespace temp;
create user tts002 identified by tts002 default tablespace tts001 temporary tablespace temp;
grant connect, resource to tts001, tts002;

--- create a table in schema 1
connect tts001/tts001

create table a_tab (id number);
insert into a_tab values (1);
commit;

--- create a table in schema 2
connect tts002/tts002

create table b_tab (id number);
insert into b_tab values (1);
commit;

-- connect to user 1 and drop the table. The user doesn't
-- have any objects in tablespace TTS001. But a temporary
-- object exists in recyclebin
connect tts001/tts001
drop table a_tab;

-- put the tablespace in read only mode
connect / as sysdba
alter tablespace tts001 read only;

-- Export the tablespace
#>expdp system/manager directory=dpu dumpfile=tts001.dmp transport_tablespaces=tts001

-- drop tablespace and recreate the users
drop tablespace tts001 including contents;
drop user tts001 cascade;
drop user tts002 cascade;
purge dba_recyclebin;

create user tts001 identified by tts001 default tablespace users temporary tablespace temp;
create user tts002 identified by tts002 default tablespace users temporary tablespace temp;
grant connect, resource to tts001, tts002;

-- Perform the TTS import
#> impdp system/manager directory=dpu dumpfile=tts001.dmp transport_datafiles=/tmp/tts001.dbf

This ends with:

Import: Release 10.1.0.5.0 - 64bit Production on Wednesday, 24 March, 2010 9:27

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/******** directory=dpu dumpfile=tts001.dmp transport_datafiles=/tmp/tts001.dbf
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
ORA-39123: Data Pump transportable tablespace job aborted
ORA-29344: Owner validation failed - failed to match owner 'TTS001'

Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at 09:27

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