Oracle 11 g with DMP import data show that violate the only constraints can't import-CodePudding

Oracle 11 g with DMP when importing data, shows that violate the only constraints can't import

CodePudding user response:

Posted on the specific error messages and logs

CodePudding user response:

reference 1st floor wildwave response:

posted on the specific error messages and logs

To connect to: Oracle Database 11 g Enterprise Edition Release 11.2.0.1.0-64 - bit Production
With the Partitioning, OLAP, Data Mining, and Real Application Testing options

Through direct path by EXPORT: V11.02.00 create the EXPORT file
Has been completed ZHS16GBK character sets and AL16UTF16 NCHAR import
in a character set.. is import table "ASF_PERSONAL_COMMENT
"IMP - 00019: due to the ORACLE error 1 refused to row
IMP - 00003: ORACLE error 1
ORA - 00001: a violation of the constraints (ZJHQ_EGP. SYS_C0011058)
Column: bc3ffc6c46f698f50146fb163ee80018
Column: 0
Column: 4
Column: 2 c9146a042b142a50142b142ceb80573
Column: cui-xia liu
Column: Posting
Column: usertask2
IMP - 00019: due to the ORACLE error 1 refused to row
IMP - 00003: ORACLE error 1
ORA - 00001: a violation of the constraints (ZJHQ_EGP. SYS_C0011058)
Column: bc3ffc6c46f698f50146f9eb8d8c000d
Column: 65465465
Column: 2
Column: 2 c9146a042b142a50142b142b21700a3
Column: Liu Guojun
Column: Posting
Column: usertask3
IMP - 00019: due to the ORACLE error 1 refused to row
IMP - 00003: ORACLE error 1
ORA - 00001: a violation of the constraints (ZJHQ_EGP. SYS_C0011058)
Column: ff80808147d709cb0147e7288bae0084
Column: please op, offer an opinion of the committee, submitted to the Yang, deputy secretary of the umpire,
Column: 1
Column: 2 c9146a042b142a50142b142b1200054
Column: YuJun
Column: receipt
Column: usertask18
IMP - 00019: due to the ORACLE error 1 refused to row
IMP - 00003: ORACLE error 1
ORA - 00001: a violation of the constraints (ZJHQ_EGP. SYS_C0011058)

CodePudding user response:

Did you the list of existing data, and to import the data duplication, cause the failure of import?

CodePudding user response:

reference 1st floor wildwave response:

posted on the specific error messages and logs

This statement is to import database: imp userid=zjhq_egp/oracle @ localhost/former file="zjhq_egp. DMP log"="t_zjhq_egp. The log buffer feedback=10000=100000000 fromuser=zjhq_egp touser=zjhq_egp grants=n ignore=y

CodePudding user response:

reference bw555 reply: 3/f

did you the list of existing data, and to import the data duplication, cause the failure of import?

Said I'm the new, there can be no data,

CodePudding user response:

Various methods are tried, online is non-negotiable, points minutes fired rhythm, please everyone a great god help!!!!!!!!!!

CodePudding user response:

First delete constraints, importing data, and then check data,'ll add constraint problem
Should be you import data in itself have to violate the constraint

CodePudding user response:

Are you sure the original table does not exist?
See ZJHQ_EGP. SYS_C0011058 this constraint is the only constraint on which field, to determine whether the duplicate data
If is to import a user's data, the user delete the reconstruction, try the import again

CodePudding user response:

Remove the ignore=y in import statements, I doubt you don't delete clean table, failed to perform table statements, error is ignore=y blocked

CodePudding user response:

Disable constraints to go first,
After the guide again,

CodePudding user response:

Problem solved? You set up a new user to import a try,

CodePudding user response:

Two possibilities:
1, you export the data before and after a period of time, now you are importing data, import data and original data duplication in the Treasury, so the import failure;
2, export data, the table is not the only constraint, after you added a unique constraint, then import the violation of the constraints, only natural guide doesn't come in,
Problem, you will know how to operate

CodePudding user response:

7th floor right, install 7 floor of thinking to do it

CodePudding user response:

Not again, the user directly to delete, table space delete (if special table space), to rebuild the user (reconstruction table space)

CodePudding user response:

9/f, positive solutions, you can try,

CodePudding user response:

To build a user, imported into the new user, if necessary, in the two users to do data analysis and comparison,

CodePudding user response:

1, to create a user, and then try to import
2, and if there is an error, can consider at the time of exp, add something STATISTICS INDEXES=N=NONE ROWS=Y CONSTRAINTS=N

CodePudding user response:

DMP should include the creation of a table in the table are deleted, and then guide the more simple,

CodePudding user response:

You can do this, the original table space you this table won't violate the uniqueness problems, you put the table space export to new. The DMP, then create a new table space and the new. The DMP import see report is not an error, if it is imported into a different table space, you have to use SQL statements to filter out empty table and there is no record table, you'll have to application UltraEdit. Open your new DMP to modify the name of the table space as you need to import to the table space name, then import, under normal circumstances there is no problem, I tried many times ~

CodePudding user response:

I said above into a different table space, the operation, the premise is two table space table structure are exactly the same, only the table space and the owner is not the same ~

CodePudding user response:

Thinking: delete the existing constraints, add constraints after import
When the import violates the constraint conditions