Home » RDBMS Server » Server Utilities » IMPDP error ORA-39168 (Oracle 11g)
IMPDP error ORA-39168 [message #627834] Mon, 17 November 2014 07:06 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: IMPDP error ORA-39168 [message #627837 is a reply to message #627835] Mon, 17 November 2014 07:18 Go to previous messageGo to next message
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.
Re: IMPDP error ORA-39168 [message #627841 is a reply to message #627837] Mon, 17 November 2014 07:47 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

OK now the other questions.

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


Current Time: Thu Mar 28 04:10:00 CDT 2024