impdp "failed to load/unload" master table
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-lReceived on Fri Jan 15 2010 - 09:34:41 CST