Hi. I Have 2 database tables. One called AD_USER and the other called AD_CHANGELOG. The table AD_CHANGELOG has a foreign key constraint AD_USER_ID which is a primary key of the AD_USER table. To delete some records from AD_USER table I disabled the foreign key constraint with the following statement :
It did disable the constraint and I was able to delete the rows in AD_USER table. But after that, I found that my oracle DB every night for the last 2 days starting from 8 pm onwards starts running a
ALTER TABLE AD_CHANGELOG statement which takes up lot of cpu time and hangs the websites which I am running. I then manually have to kill the session that runs this sql and then things are normal again. I do not understand what to do. Should I try to run a alter statement to enable the constraint that I had disabled. I am really worried. I think oracle runs the DBA_ReCompile process every night and thats when this alter statement is run again I guess.
If anybody could throw some light. Thanks