Home » RDBMS Server » Server Utilities » Error During Import
Error During Import [message #205981] Tue, 28 November 2006 04:52 Go to next message
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.
Re: Error During Import [message #205985 is a reply to message #205981] Tue, 28 November 2006 04:59 Go to previous message
Frank Naude
Messages: 4506
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:
Previous Topic: SQLLDR date format problem
Next Topic: SQL Loader Syntax Help
Goto Forum:

Current Time: Sun Feb 26 09:26:53 CST 2017

Total time taken to generate the page: 0.14552 seconds