Modify the table to add the default value of the field default

Add one field to the tables in the production database. The field type is INT type, and the table data contains tens of millions. alter table table_name add xxoo number (4) default 0;

Therefore, you must not only modify the dictionary, but also refresh all the data.

1) if there is a default value in ALTER SQL, ORACLE will directly refresh all records.
2) There is no default value in ALTER SQL. ORACLE will only affect subsequent records.

 
Executed in 0.062 seconds

Alter table table_name add xxoo number (4) default 0;
 
Table altered

Where B. lock_id1 = 33784 and a. SID = B. session_id
And a. SQL _ADDRESS = c. ADDRESS;