Just quick note for anyone getting this error. It took me a little while to figure out. There can a be a various reasons for MySQL errno 150. Following are the ways to verify your structure in order to fix your problem 1) type of foreign key source and reference fields must be identical check: both set...

Identify the Session to be Killed Killing sessions can be very destructive if you kill the wrong session, so be very careful when identifying the session to be killed. If you kill a session belonging to a background process you will cause an instance crash. Identify the offending session using the V$SESSION...