Imp Failed With Error 907: Alter Table ... Ora-00907: Missing Right Parenthesis (Doc ID 375851.1)

Last updated on NOVEMBER 15, 2007

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.2.6
This problem can occur on any platform.
Export from 9.2.0.6 database and import attempted into 9.2.0.6 database results in errors.

Symptoms

Export from 9.2.0.6 database and import attempted into 9.2.0.6 database results in errors.

 

IMP-00017 FOLLOWING STATEMENT FAILED WITH oracle ERROR 907:
" aLTER TABLE "X" MODIFY ("COL_NAME" DEFAULT 0"
IMP-00003: oRACLE ERROR 907 ENCOUNTERED
IMP-00017: FOLLOWING STATEMENTS FAILED WITH ORACLE ERROR 907:
"ALTER TABLE "X" MODIFY ("COL_NAME" DEFAULT 0"
IMP-00003: ORACLE ERROR 907 encountered
ORA-00907: missing right parenthesis


.
Verified from the error report.

.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms