Table with foreign key constraint is in being loaded status
We have got a problem described as follows:
* When we try to access table AAA, the error occurs: Operation not allowed: AAA is being loaded. * We tried releasing the lock but this error still exist. * Then we tried to drop the table AAA, but the table AAA has Foreign Key constraints and hence we couldn't drop the table. The error message is?*** Failure 5313 Referential integrity violation: cannot drop a referenced (Parent) table. * We then tried Altering the child table to drop the constraints but even this operation is not allowed as the table AAA is being loaded.
Please advice if any solution or suggestion for this. Thank you!