process killed for table column addition
A column was added to a 14 million row table with a default value. The processes was killed becuase it was taking resources/time. After the session was marked for kill, the table lost the primary key and 2 foreign keys. Any idea on how to find out how long the SMON process will take to clean up. Any possible explaination why the table dropped the primary key and a few constraints.
Re: process killed for table column addition
Quote:
Originally posted by Natik
Any possible explaination why the table dropped the primary key and a few constraints.
No, there's absolutely no reason for that. And I find it extremely strange if that is what realy happened. Are you sure that the addition of a new column and the lost of constraints are corelated? I highly doubt that, but if you are sure that's what realy happened you should report this to Oracle Support.
Re: process killed for table column addition
Quote:
Originally posted by Natik
A column was added to a 14 million row table with a default value. The processes was killed becuase it was taking resources/time. After the session was marked for kill, the table lost the primary key and 2 foreign keys. Any idea on how to find out how long the SMON process will take to clean up. Any possible explaination why the table dropped the primary key and a few constraints.
It might be worth using logminer to investigate, if you think that's what really happened.