Dropping an unsed column???
I have done the following steps
1. ALTER TABLE Salary DROP UNUSED COLUMNS CHECKPOINT 1000; -- started 06:00 BST
2. Killed at 17/01/2010 09:00 BST
3. ALTER TABLE Salary DROP COLUMNS CONTINUE ;- again started at 09:57 BST
Has been running for >26 hours now and is causing major issues, because no other sessions can query the table.
Customer requirements:
- Is there a way to find out how long this will take? How can we monitor progress?
- Is it possible to cancel or roll this back and would this be quicker?
- Are there any ways to speed up the drop? E.g. changing parallelism or changing the checkpoint value?
1. ALTER TABLE Salary DROP UNUSED COLUMNS CHECKPOINT 1000; -- started 06:00 BST
2. Killed at 17/01/2010 09:00 BST
3. ALTER TABLE Salary DROP COLUMNS CONTINUE ;- again started at 09:57 BST
Has been running for >26 hours now and is causing major issues, because no other sessions can query the table.
Customer requirements:
- Is there a way to find out how long this will take? How can we monitor progress?
- Is it possible to cancel or roll this back and would this be quicker?
- Are there any ways to speed up the drop? E.g. changing parallelism or changing the checkpoint value?
0