OraFAQ Forum: Server Utilities » Error During Import

Home » RDBMS Server » Server Utilities » Error During Import

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

Error During Import [message #205981]

Tue, 28 November 2006 04:52

mallelaraja
Messages: 1
Registered: November 2006

Junior Member

Dear All,

I was trying to import a with the below command

imp system/manager@phiefb fromuser="pefbuser" touser="produser"
file="pefb.dmp" ignore=Y

During Import I am getting the Error

ORA-00922: Oracle 922 error encountered

with the create table "table name" entire source code gets displayed and finally import terminated with warnings.

Please suggest what could be the problem.

Report message to a moderator

Re: Error During Import [message #205985 is a reply to message #205981]

Tue, 28 November 2006 04:59

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Are you maybe exporting and importing between different Oracle versions?

Also, please post the complete error message with the statement that is causing the problem.

00922, 00000, "missing or invalid option"
// *Cause:
// *Action:

Report message to a moderator

Previous Topic:	SQLLDR date format problem
Next Topic:	SQL Loader Syntax Help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 23:35:08 CST 2024