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: 4509
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: Tue Jul 25 15:55:37 CDT 2017

Total time taken to generate the page: 0.05282 seconds