Database Administration (MOSC)

MOSC Banner

How to purge objects in recyclebin that's not physically in recyclebin?

edited Dec 29, 2016 3:57PM in Database Administration (MOSC) 3 commentsAnswered ✓

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center