var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: column taking too long to drop
I created a new 10g (10.2.0.5.0)db and am in the process of adding tables to it. In one particular table I added some columns by mistake and am now trying to drop them using:
alter table drop column_name;
but this is taking absolutely ages. I've tried this through Toad and SQLPLUS. I've been shut the db down and restarted it but no good.
Can anyone please advise?
Is there any foreign key constraint that relates to that column? If so, try to disable (or drop) it first.
My guess is, that some other process is still using that table and therefor you cannot run DDL on it.
Thanks for the replies guys. I couldn't figure out why but did read that dropping a column, the whole table is re-written. So I just set the columns in question 'unused'.