Re: impdp "failed to load/unload" master table

[oracle_at_tds prod8]$ pwd
/u04/exports/prod8
[oracle_at_tds prod8]$ ls -l expdat.dmp
-rw-r----- 1 oracle dba 2733584384 Jan 14 11:07 expdat.dmp

On Fri, Jan 15, 2010 at 10:34 AM, Masha Gurenich <gurenich_at_gmail.com> wrote:

> 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