How to purge objects in recyclebin that's not physically in recyclebin?
One of the PK column is showing as recycle bin name? This is Oracle 12.1.0.2 on Solaris.
CONSTRAINT_NAME C TABLE_NAME INDEX_NAME INVALID STATUS--------------------------------- - --------------------- --------------------------------- ------- --------BIN$OKDzqPSxAITgU6gopOZC9g==$0 P CTRAC_DOCM CTRAC_DOCM_CTDOCM_ID_PK ENABLED
When I view the recycle bin, its empty.
SYS:hsco1 > select * from dba_recyclebin where OWNER='SCOAUT';no rows selected
I want to rename the above constraint. is this doable?
1