Cause
There were multiple tables matching the specified table in the ALTER TABLE EXCHANGE [SUB]PARTITION CASCADE command.
There were multiple tables matching the specified table in the ALTER TABLE EXCHANGE [SUB]PARTITION CASCADE command.
Before performing the TRUNCATE operation on the table, disable the foreign key constraints in other tables. You can see what constraints exist in a table by issuing the following command: SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = :1;
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm
Browse all solutions to database errors from Oracle, MS SQL, or MySQL