Use SQL statements copy reader table form the same table reader2, why would update the reader ORA0001's mistakes, and update reader2 can succeed?

CodePudding user response:

with SQL statement copy reader table form the same table reader2

Do you want to post your sentences,

The replication of different statements, copy the contents of the different,

You now the scene, is clearly reader2 didn't put the reader on the PK or copied to chassis, so don't complain,

CodePudding user response:

On the first floor said makes sense,
Had better not concrete operating post and see,

CodePudding user response:

The create table as the select the replication table won't duplicate indexes and constraints

CodePudding user response:

Reader table copied into reader2, duplicate table read2 is no indexes and constraints, so update read2 is successful,