Shutdown hangs Cancel "DROP COLUMN"

[Dilippatel]

Hi,

We were trying to drop column on a very big table, after that we cancelled that operation, and given shutdown immediate command.

Now shutdown is taking too much time, going on from last 9 hours.....

We want to start the database, what can be the best possible solution.

Shutdown abort and startup will help ?

Thanks

Dilipkumar Patel.

[abhaysk]

It will not help.. The cancel on that operation is getting rolled back.