Home » RDBMS Server » Server Utilities » IMP-00051: Direct path exported dump file contains illegal column length (oracle 9.2.0.5 on AIX 5)
IMP-00051: Direct path exported dump file contains illegal column length [message #314517] Thu, 17 April 2008 00:55 Go to next message
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
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 Go to previous messageGo to next message
gopu_g
Messages: 54
Registered: March 2008
Location: mumbai
Member

which is your oracle version ?
which is your OS ?
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 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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)
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 25035
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
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 Go to previous messageGo to next message
gopu_g
Messages: 54
Registered: March 2008
Location: mumbai
Member

Hi,

you please try in CONVENTIONAL path

gopu
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 Go to previous messageGo to next message
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.
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 Go to previous message
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:
  


Current Time: Sat Dec 03 20:35:07 CST 2016

Total time taken to generate the page: 0.12294 seconds