|
The problem looks like this:
Originally, I exported a table from an ORACLE, and then imported it in another database, and then reported the following error, please let me know which heroes have encountered:
The error message is as follows:
Warning: This object was exported by ZY1209, not the current user
The ZHS16GBK character set and the AL16UTF16 NCHAR character set have been imported
IMP-00017: The following statement failed due to Oracle's 907 error
"ALTER TABLE" BUSI_T_BUSINESSDOCUMENT "MODIFY (" STOPYEAR "DEFAULT 0"
IMP-00003: ORACLE error 907 encountered
ORA-00907: missing right parenthesis
IMP-00017: The following statement failed due to a 942 error in Oracle
"ALTER TABLE" BUSI_T_BUSINESSDOCUMENT "ADD CONSTRAINT" BUSI_F_BSNSDOC01 "FOR"
"EIGN KEY (" DOCUMENTTYPENO ") REFERENCES" PUB_T_DOCUMENTTYPE "(" DOCUMENTTYPEN "
"O") ENABLE NOVALIDATE "
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
Ready to enable constraints ...
IMP-00017: The following statement failed due to a 942 error in Oracle
"ALTER TABLE" BUSI_T_BUSINESSDOCUMENT "ENABLE CONSTRAINT" BUSI_F_BSNSDOC01 ""
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
Import terminated successfully with warning.
F:\> |
|