Alter table parallel operations

Alter table open parallel operation use alter table open parallel first create a table create table a_test (name varchar2 (10) insert into a_test values ('aaa'); select * from a_test; NAME ---- aaa add an age and then use the parallel alter table a_test parallel 6 add AGE number (10) default 18; select * from a_test; NAME age ---- --- aaa 18 to view the parallel strength select table_name, degree from dba_tables where table_name = 'A _ test'; TABLE_NAME DEGREE ---------- A_TEST 6 do not forget Parallel processing. Alter table A_TEST noparallel;