Home » RDBMS Server » Server Utilities » ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload
ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload [message #476713] Fri, 24 September 2010 14:48 Go to next message
d158tech
Messages: 5
Registered: September 2010
Junior Member
Not sure if this is in the right forum, if not, my apologies....anyhow,

Hello to All....Any advice or recommendations someone could give me regarding the following....I appreciate it...

ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload
ORA-31640: unable to open dump file "D:\oradata\PSPRODDB\data_pump_dir\powerschool-fri.dmp" for read
ORA-19505: failed to identify file "D:\oradata\PSPRODDB\data_pump_dir\powerschool-fri.dmp"
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 2192117862)

If there is more info you need, please ask.

Thanks

Report message to a moderator

Re: ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload [message #476714 is a reply to message #476713] Fri, 24 September 2010 14:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Could be useful if you provide the the Oracle Versions involved
and
what you are trying to do with impdp.

Did you transfer the files? FTP from *nix machines?
If so, make sure you did it in BIN mode

[Updated on: Fri, 24 September 2010 15:00]

Report message to a moderator

Re: ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload [message #476715 is a reply to message #476714] Fri, 24 September 2010 15:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
 
ORA-27046: file size is not a multiple of logical block size
 *Cause:  file size as indicated by stat is not correct, additional
          information indicates which function encountered the error
 *Action: verify that the file has not been overwritten or truncated

Regards
Michel

Report message to a moderator

Re: ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload [message #476716 is a reply to message #476714] Fri, 24 September 2010 15:07 Go to previous messageGo to next message
d158tech
Messages: 5
Registered: September 2010
Junior Member
The version that we have is 10.2.0.4.0

And we FTP them in binary.

Report message to a moderator

Re: ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload [message #476717 is a reply to message #476715] Fri, 24 September 2010 15:12 Go to previous messageGo to next message
d158tech
Messages: 5
Registered: September 2010
Junior Member
How do you verify that the file has not been truncated? We had to get the data from a data recovery company. So it needed to be recreated from a RAID 5 Configuration.

Report message to a moderator

Re: ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload [message #476719 is a reply to message #476717] Fri, 24 September 2010 15:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Are source and target systems the same one?

Regards
Michel

Report message to a moderator

Re: ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload [message #476721 is a reply to message #476719] Fri, 24 September 2010 15:30 Go to previous messageGo to next message
d158tech
Messages: 5
Registered: September 2010
Junior Member
Well the original machine went belly up. So we had to send the drives to a data recovery company. So we have a new server with the same OS and Oracle version.

Report message to a moderator

Re: ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload [message #476722 is a reply to message #476721] Fri, 24 September 2010 15:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Ask your sysadmin to verify file consistency.

Regards
Michel

Report message to a moderator

Re: ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload [message #476724 is a reply to message #476722] Fri, 24 September 2010 15:42 Go to previous messageGo to next message
d158tech
Messages: 5
Registered: September 2010
Junior Member
Is there a command that we can use that will verify it for us? Or can you point me in the direction on how to go about verifing tje fille?

Report message to a moderator

Re: ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload [message #476730 is a reply to message #476724] Fri, 24 September 2010 16:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
imp show=yes may provide clues or insight

Report message to a moderator

Re: ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload [message #476731 is a reply to message #476724] Fri, 24 September 2010 16:41 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Two other possibilities.
Either this file is not created by expdp
or
There might be more than one file involved.
Try to get those export session logs.

Report message to a moderator

Previous Topic: Data Pump Inquiry
Next Topic: data pump import error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 10:28:57 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.