OraFAQ Forum: Server Utilities » IMPDP error ORA-39168

Home » RDBMS Server » Server Utilities » IMPDP error ORA-39168 (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IMPDP error ORA-39168 [message #627834]

Mon, 17 November 2014 07:06

Tintin68
Messages: 2
Registered: October 2014

Junior Member

Hello,

I want to import the table and the data only.

I try with the parameter include = TABLE or include = TABLE_DATA.
But I have the error "ORA-39168 : object path TABLE not found".

How can I do ?

[Updated on: Mon, 17 November 2014 07:08]

Report message to a moderator

Re: IMPDP error ORA-39168 [message #627835 is a reply to message #627834]

Mon, 17 November 2014 07:08

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Source database version (4 decimals, ex. 11.2.0.3), export command, target database version, import command?
Export log and import log with the error?
Before, please read How to use [code] tags and make your code easier to read.

Report message to a moderator

Re: IMPDP error ORA-39168 [message #627837 is a reply to message #627835]

Mon, 17 November 2014 07:18

Tintin68
Messages: 2
Registered: October 2014

Junior Member

import command
==========
impdp directory=DB_EXPORT schemas=S1 remap_schema=S1:S2 include=TABLE dumpfile=EXP.DMP logfile=err.log

log
===
Import: Release 11.2.0.1.0 - Production on Lun. Nov. 17 14:02:00 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
Connecté à : Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Table maître "SYSTEM"."SYS_IMPORT_SCHEMA_03" chargée/déchargée avec succès
ORA-39168: Le chemin d'objet TABLE est introuvable.

Report message to a moderator

Re: IMPDP error ORA-39168 [message #627841 is a reply to message #627837]

Mon, 17 November 2014 07:47

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

OK now the other questions.

Report message to a moderator

Previous Topic:	Using VERSION keyword while export.
Next Topic:	Problem loading data using SQL Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 24 00:30:43 CDT 2025