Oracle 在线表移动到不同的表空间。

c##rajesh@PDB1> alter session set ddl_lock_timeout =300;

Session altered.

c##rajesh@PDB1> show parameter ddl_lock_timeout

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
ddl_lock_timeout                     integer     300

c##rajesh@PDB1> set timing on time on
18:19:27 c##rajesh@PDB1> alter table app_legacy.APP_CLM_PRF nologging;

Table altered.

Elapsed: 00:00:00.03
18:19:39 c##rajesh@PDB1> alter table app_legacy.APP_CLM_PRF move tablespace TS_QPNY_CLM_PRF_5010 online PARALLEL 8;
alter table app_legacy.APP_CLM_PRF move tablespace TS_QPNY_CLM_PRF_5010 online PARALLEL 8
                       *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-12801: error signaled in parallel query server P00Q, instance en702c101vm01.us1.ocm.s1234567.oraclecloudatcustomer.com:PDB1 (1)
ORA-04021: timeout occurred while waiting to lock object app_legacy.SYS_RMTAB$$_H229541