Is it possible to execute a alter table drop unused columns parallel?
No.
Only following DDL can be executed parallel (in 10g):
The parallel DDL statements for nonpartitioned tables and indexes are:
- CREATE INDEX
- CREATE TABLE … AS SELECT
- ALTER INDEX … REBUILD
For Partitioned Tables:
- CREATE INDEX
- CREATE TABLE … AS SELECT
- ALTER TABLE … [MOVE|SPLIT|COALESCE] PARTITION
- ALTER INDEX … [REBUILD|SPLIT] PARTITION
Btw: If you find my articels useful, support me with a click to the google adds.