This forum is currently locked. You can't register or post questions at this time. (read more)

11.1.0.6 Impdp error when restoring a table via remap_table

All posts relating to Oracle database administration.

Moderator: Tim...

jrmtl
Senior Member
Posts: 203
Joined: Tue Feb 22, 2005 7:08 pm
Location: Montreal

11.1.0.6 Impdp error when restoring a table via remap_table

Postby jrmtl » Mon Aug 19, 2013 5:24 pm

Hello,

Does anyone have an idea as to this error when trying to restore a table from an older export of same table to a new temporary table .

D:\app\oracle\product\11.1.0\db_1\BIN>impdp system directory=xxx dump
ile=xxxx.DMP tables=xxx.xyz remap_table=xxx.xyz:abc_temp
logfile=ETF_KF26july.log

Import: Release 11.1.0.6.0 - 64bit Production on Monday, 19 August, 2013 13:11:
4

Copyright (c) 2003, 2007, Oracle. All rights reserved.
Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-31694: master table "SYSTEM"."SYS_IMPORT_TABLE_01" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-39776: fatal Direct Path API error loading table "SYSTEM"."SYS_IMPORT_TABLE
01"
ORA-00600: internal error code, arguments: [klaprs_11], [], [], [], [], [], [],
[]

thx !

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: 11.1.0.6 Impdp error when restoring a table via remap_ta

Postby Tim... » Mon Aug 19, 2013 5:32 pm

Hi.

It's an ORA-00600, so I used the MOS lookup tool.

https://support.oracle.com/epmos/faces/ ... d=153788.1

That pointed me to this bug.

https://support.oracle.com/epmos/faces/ ... =1359213.1

It's fixed in 11.1.0.7 or 11.2.0.1.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

jrmtl
Senior Member
Posts: 203
Joined: Tue Feb 22, 2005 7:08 pm
Location: Montreal

Re: 11.1.0.6 Impdp error when restoring a table via remap_ta

Postby jrmtl » Mon Aug 19, 2013 5:50 pm

Thx for that Tim ...

maybe i`ll restore i another db

JR

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: 11.1.0.6 Impdp error when restoring a table via remap_ta

Postby Tim... » Mon Aug 19, 2013 6:22 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 7 guests

cron