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

IMPDP error

All posts relating to Oracle database administration.

Moderator: Tim...

jayakrishna
Member
Posts: 10
Joined: Thu Mar 15, 2012 7:01 am

IMPDP error

Postby jayakrishna » Fri Jul 19, 2013 12:35 pm

I have exported full db from test db and while importing into another db iam getting below error.
please help me.

[jay@oraserver hasexp]$ impdp system directory=EXPORT dumpfile=full.dmp full=y

Import: Release 10.2.0.1.0 - Production on Friday, 19 July, 2013 17:55:23

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-31694: master table "SYSTEM"."SYS_IMPORT_FULL_01" failed to load/unload
ORA-31640: unable to open dump file "/ora1/hasexp/full.dmp" for read
ORA-19505: failed to identify file "/ora1/hasexp/full.dmp"
ORA-27046: file size is not a multiple of logical block size
Additional information: 1

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

Re: IMPDP error

Postby Tim... » Fri Jul 19, 2013 1:15 pm

Hi.

Questions:

1) Was this an export created using expdp or exp?
2) Was it transferred between servers as a binary or ascii?
3) Is the file in the locations "/ora1/hasexp/full.dmp"?
4) Does the "oracle" operating system have privilege to read/write that location?

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

jayakrishna
Member
Posts: 10
Joined: Thu Mar 15, 2012 7:01 am

Re: IMPDP error

Postby jayakrishna » Fri Jul 19, 2013 1:47 pm

Hi Tim,

1) i have taken export as expdp
[jay@oraserver ~]$ expdp dumpfile=full.dmp directory=export full=y logfile=demo.log

2)iam importing in the same server but on different database, from db test to db jay

3)yes dump file is available in the location
[jay@oraserver hasexp]$ ls
demo.log full.dmp import.log

4)we have permissions on it.
[jay@oraserver hasexp]$ ls -ltr
total 62972
-rwxrwxrwx 1 jay oinstall 54706 Jul 15 11:24 demo.log
-rwxrwxrwx 1 jay oinstall 64331777 Jul 15 11:25 full.dmp
-rwxrwxrwx 1 jay oinstall 569 Jul 19 19:13 import.log

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

Re: IMPDP error

Postby Tim... » Fri Jul 19, 2013 3:59 pm

Hi.

Was the export done from a server with a version higher than the version you are importing into?

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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 0 guests