Answer Mr. Cotton Candy's question about the auto-increment index of my DB

I have previously mentioned in many articles the problem of logstdby status: ORA-01418, logical standby may be that the database automatically increases the index, causing logical standby to fail to apply. the reason was accidentally discovered today, because the AP staff did not specify a name when adding unique constraints, Oracle automatically assigned one, and this SQL specifies another name when standby applies. the test is as follows:

Create Table kevinsun

(

ID number,

Ename varchar2 (20 byte ),

Cname varchar2 (20 byte)

)

;

 

Alter table kevinsun add (

Unique (ID)

Using Index

;

An index named sys_c0013150 is generated on the master database, and an index named sys_c0014150 is generated on the slave database.