grant EXECUTE_CATALOG_ROLE,CREATE ANY TABLE,ALTER ANY TABLE,DROP ANY TABLE,LOCK ANY TABLE,SELECT ANY TABLE to &用戶名;
或者直接使用DBA用戶。

begin
 dbms_redefinition.can_redef_table(uname        => &user,
                                   tname        => &table,
                                  options_flag => dbms_redefinition.CONS_USE_PK);
end;
/

alter session force parallel dml parallel &并行度;
alter session force parallel query parallel &并行度;

CREATE TABLE scott.emp_tmp
  ( 
EMPNO NUMBER(4) not null,
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(7,2),
COMM NUMBER(7,2),
DEPTNO NUMBER(2) 
) 
 partition BY range(EMPNO) 
 ( 
 partition tab_part_2020 VALUES less than  (7700), 
 partition tab_part_2021 VALUES less than  (7900),
  partition tab_part_2022 values less than(maxvalue)
 );

BEGIN
 DBMS_REDEFINITION.START_REDEF_TABLE(uname  => &用戶名,
                                     orig_table  => &源表名,
                                     int_table   => &臨時表名,
   col_mapping => null,
                                    options_flag => dbms_redefinition.cons_use_pk
                                     );
END;
/

ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-14400: inserted partition key does not map to any partition

select * from dba_mview_logs where log_owner=SCOTT;
select MVIEW_NAME,CONTAINER_NAME,QUERY from dba_mviews where owner=SCOTT;
drop materialized view log on scott.emp1;
drop materiallized view scott.emp_tmp;

DECLARE
error_count PLS_INTEGER :=0;
BEGIN
DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS(uname  => &用戶名,
                                       orig_table       => &源表名,
                                       int_table        => &臨時表名,
                                       copy_indexes     => DBMS_REDEFINITION.CONS_ORIG_PARAMS,
                                       copy_triggers    => TRUE,
                                       copy_constraints => TRUE,
                                       copy_privileges  => TRUE,
                                       ignore_errors    => true,
                                       num_errors     => error_count,
                                       copy_statistics  => FALSE );
DBMS_OUTPUT.PUT_LINE(errors :=  || TO_CHAR(error_count));
END;

ERROR at line 1:
ORA-01442: column to be modified to NOT NULL is already NOT NULL

select * from DBA_REDEFINITION_ERRORS;

SELECT CONSTRAINT_NAME, VALIDATED FROM USER_CONSTRAINTS WHERE TABLE_NAME = &表名;

ALTER TABLE &表名 ENABLE VALIDATE CONSTRAINT &約束名稱;

SELECT CONSTRAINT_NAME, VALIDATED FROM USER_CONSTRAINTS WHERE TABLE_NAME = &表名;

BEGIN
 DBMS_REDEFINITION.SYNC_INTERIM_TABLE(uname      => &用戶名,
                                      orig_table => &源表名,
                                      int_table  => &臨時表名
                                      );
END;

BEGIN
 DBMS_REDEFINITION.FINISH_REDEF_TABLE(uname      => &用戶名,
                                      orig_table => &源表名,
                                      int_table  => &臨時表名
                                      );
END;

EXEC DBMS_STATS.gather_table_stats(&用戶名, &表名, cascade => TRUE,no_invalidate => FALSE);

SELECT ALTER INDEX  || INDEX_OWNER || . || INDEX_NAME ||
      REBUILD PARTITION  || PARTITION_NAME ||  NOLOGGING online;
 FROM DBA_IND_PARTITIONS
WHERE INDEX_OWNER NOT IN (SYS, SYSTEM, PUBLIC)
  AND STATUS = UNUSABLE
UNION ALL
SELECT alter index  || OWNER || . || A.INDEX_NAME ||
       REBUILD online nologging;
 FROM DBA_INDEXES A
WHERE OWNER NOT IN (SYS, SYSTEM, PUBLIC)
  AND STATUS = UNUSABLE;

select * from dba_objects where status<>VALID and owner=&用戶名;

truncate table &臨時表名;
drop table &臨時表名;