OraFAQ Forum: Server Utilities » IMP-00051: Direct path exported dump file contains illegal column length

Home » RDBMS Server » Server Utilities » IMP-00051: Direct path exported dump file contains illegal column length (oracle 9.2.0.5 on AIX 5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IMP-00051: Direct path exported dump file contains illegal column length [message #314517]

Thu, 17 April 2008 00:55

lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi

Member

Hi All,
I have faced a issue while importing a dump file that was exported with "direct = y" option using export utility. while importing it throws an error message given below:

IMP-00051: Direct path exported dump file contains illegal column length
IMP-00008: unrecognized statement in the export file:
��^C

I tried this several times by exporting the data again and importing it. But all in vain.
But when i exported the data without direct=y option. It works Smile

.
Can you please give your input regarding this issue.
Thanks in advance.
Regards
Lalit

Report message to a moderator

Re: IMP-00051: Direct path exported dump file contains illegal column length [message #314655 is a reply to message #314517]

Thu, 17 April 2008 07:07

gopu_g
Messages: 54
Registered: March 2008
Location: mumbai

Member

which is your oracle version ?
which is your OS ?

Report message to a moderator

Re: IMP-00051: Direct path exported dump file contains illegal column length [message #314665 is a reply to message #314655]

Thu, 17 April 2008 07:41

Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

Home � RDBMS Server � Server Utilities � IMP-00051: Direct path exported dump file contains illegal column length (oracle 9.2.0.5 on AIX 5)

Report message to a moderator

Re: IMP-00051: Direct path exported dump file contains illegal column length [message #314669 is a reply to message #314665]

Thu, 17 April 2008 07:47

gopu_g
Messages: 54
Registered: March 2008
Location: mumbai

Member

Littlefoot wrote on Thu, 17 April 2008 07:41

Quote:

Home � RDBMS Server � Server Utilities � IMP-00051: Direct path exported dump file contains illegal column length (oracle 9.2.0.5 on AIX 5)

Sorry man.... Smile

Report message to a moderator

Re: IMP-00051: Direct path exported dump file contains illegal column length [message #314680 is a reply to message #314517]

Thu, 17 April 2008 08:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

4.IMP-00046; IMP-00008; IMP-00051;
Suggestion : use DIRECT=n and use BINARY MODE for transfer dump file through FTP

Report message to a moderator

Re: IMP-00051: Direct path exported dump file contains illegal column length [message #314820 is a reply to message #314517]

Thu, 17 April 2008 22:34

gopu_g
Messages: 54
Registered: March 2008
Location: mumbai

Member

Hi,

you please try in CONVENTIONAL path

gopu

Report message to a moderator

Re: IMP-00051: Direct path exported dump file contains illegal column length [message #314834 is a reply to message #314517]

Thu, 17 April 2008 23:59

lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi

Member

Thanks everybody for your instant reply.
My databases are running on oracle version 9.2.0.5 on AIX platform version 5.0.
I have already used conventional path and the it is working fine. Smile

My question is that why i am facing the issue with direct path export.

Report message to a moderator

Re: IMP-00051: Direct path exported dump file contains illegal column length [message #314836 is a reply to message #314834]

Fri, 18 April 2008 00:07

gopu_g
Messages: 54
Registered: March 2008
Location: mumbai

Member

Hi,
this is some what difficult to get rid of fromIMP-00051 error. The direct=y option is a buggy.I am not able to find a workaround available for this error.

that why we suggested to you please do not perform DIRECT path export.Use CONVENTIONAL path only.

regards
Gopu

[Updated on: Fri, 18 April 2008 00:08]

Report message to a moderator

Previous Topic:	Upgradation 9i R2 to 10g R2
Next Topic:	Sql*loader - How can I skip filed from tab delimitted file?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 02:53:19 CDT 2024