So for a weird reaon my table was dropped but the constraints remained so I cannot recreate the table with the same constraints.. Is there a way I can drop those constraints?
When I do a select in the all_constraints table:
select * from all_constraints where CONSTRAINT_NAME like 'C710%';
I get this: ("x" being the table_name which means the table doesnt exist?)
C710_C700_INT_MESSAGE_ID_FK R x
C710_INT_PROFILE_PK P x
C710_UPDATED_TS_CK C x
I tried PURGE RECYCLEBIN; with no success