Table with foreign key constraint is in being loaded status

UDA

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!
1 REPLY
Teradata Employee

Re: Table with foreign key constraint is in being loaded status

Ideally release lock and /or override should have helped....

Alternatively try dropping the child table (may be after taking backup as applicable) first and attempt a drop on parent table now....( make sure that there are no triggers etc defined on this table)