Re: impdp "failed to load/unload" master table
- From: Masha Gurenich <gurenich@xxxxxxxxx>
- To: Oracle L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 15 Jan 2010 10:37:52 -0500
And yeah, the file is there for sure:
[oracle@tds prod8]$ pwd
/u04/exports/prod8
[oracle@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@xxxxxxxxx> 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@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@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@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@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
>
>
>
>
Other related posts:
