| |

VerySource

 Forgot password?
 Register
Search
View: 9|Reply: 4

ORACLE import problems?

[Copy link]

1

Threads

3

Posts

4

Credits

Newbie

Rank: 1

Credits
4

 China

Post time: 2020-3-6 16:30:01
| Show all posts |Read mode
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:\>
Reply

Use magic Report

1

Threads

3

Posts

4

Credits

Newbie

Rank: 1

Credits
4

 China

 Author| Post time: 2020-5-22 23:45:01
| Show all posts
Attached sentence, the normal exit when exporting!
Reply

Use magic Report

0

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 Invalid IP Address

Post time: 2020-5-23 09:15:02
| Show all posts
Warning: This object was exported by ZY1209, not the current user
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
Reply

Use magic Report

0

Threads

66

Posts

45

Credits

Newbie

Rank: 1

Credits
45

 Germany

Post time: 2020-5-24 13:45:02
| Show all posts
ORA-00907: missing closing bracket
 Is the fundamental problem,
Look at the error before
Reply

Use magic Report

1

Threads

3

Posts

4

Credits

Newbie

Rank: 1

Credits
4

 China

 Author| Post time: 2020-6-1 00:45:01
| Show all posts
It has been solved, because the field created in the field in the data table was not empty but also specified a default value, so there was a problem when importing!

Very strange, is this a bug of ORACLE!
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list