Link to home
Start Free TrialLog in
Avatar of lium1
lium1

asked on

Drop foreign key constraint

SQL ERROR: ORA-04021: timeout occurred while waiting to lock object.
Avatar of Qlemo
Qlemo
Flag of Germany image

The corresponding table could not be locked within the time allowed.
Avatar of lium1
lium1

ASKER

I meant how to solve this issue. I am trying to add constraint foreign_key with enable and validate where I got an timeout error.
ASKER CERTIFIED SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"You can't do that" can be a valid and appropriate answer. If there is no way, there is none.