Can Alter tables to Modify Column sizes be parallelized
816802Mar 6 2013 — edited Mar 6 2013Hi All,
Can Alter tables to Modify Column sizes be parallelized.
I was able to define explain plan for the parallelized CREATE INDEX and CREATE TABLE STATEMENTS and view the explain plan.
But when I am trying to apply PARALLEL operation for an ALTER TABLE to modify column size, explain plan is failing.
Ex:
EXPLAIN PLAN FOR ALTER /*+ PARALLEL(10) */ TABLE EMP_BLKP_1 MODIFY ENAME VARCHAR2(40);
ORA-00900: invalid SQL statement
But when I execute the same ALTER Statement outside the explain plan it is working fine. But I do not know whether the parallelism is applied for this alter command.
Appreciate your response.
Thanks,
MK.