impdp "failed to load/unload" master table

From: Masha Gurenich <gurenich_at_gmail.com>
Date: Fri, 15 Jan 2010 10:34:41 -0500
Message-ID: <ebb6b7321001150734m65d59ad1l78e9056a5ec34ebd_at_mail.gmail.com>



Hi listers,

I am stuck with the error that I do not know how to resolve: i am trying to make an import using data pump and it fails. Please, look below. I search google and implemented all suggestions:

10:31:08 db_manager_at_prod8> select * from dba_directories 10:31:20 2 where DIRECTORY_NAME='DATA_PUMP_PROD8';

OWNER                          DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
SYS                            DATA_PUMP_PROD8

*/u04/exports/prod8*

[oracle_at_tds exports]$ ls -l
total 452
drwxr-xr-x 2 oracle dba 4096 Oct 21 09:33 lumitest
*drwxrwxrwx * 2 oracle dba 4096 Jan 15 10:25 prod8

[oracle_at_tds prod8]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jan 15 10:26:31 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
*

SQL> GRANT READ,WRITE ON DIRECTORY DATA_PUMP_PROD8 TO SYSTEM; Grant succeeded.*

SQL>
SQL>
SQL> exit

[oracle_at_tds prod8]$ impdp system/**** directory=data_pump_prod8 full=y include=table

Import: Release 10.2.0.4.0 - 64bit Production on Friday, 15 January, 2010 10:27:23

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.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_FULL_01" failed to load/unload ORA-31644: unable to position to block number 1048229 in dump file "/u04/exports/prod8/expdat.dmp"
*

I cannot find what else do I need to do in order to make this import happen.. Can you please share some hints or tricks?

Thanks before hand,
M

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 15 2010 - 09:34:41 CST

Original text of this message