Oracle Database Discussions

Oracle Database 10g

Red Hat Linux 6.4

Hi Team,

I have a table(CBS_SUM_DUN2) which was in a schema called GOVINDEN. Unfortunately I cannot see that table. Reports are not working because of that missing table.

I searched recyclebin for that user but could not locate that table.

select * from recyclebin;

ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME

---------------- ------------------------------ ------------ -------------------

BO_GL_BALANCE    BIN$dbr/mPm8nULgUNIKZRsVvA==$0 TABLE        2018-09-13:09:30:01

BO_GL_BALANCE    BIN$dbopByFFWh/gUNIKZRsMcw==$0 TABLE        2018-09-13:08:30:01

BO_GL_BALANCE    BIN$dblSdQlF3qbgUNIKZRsCrA==$0 TABLE        2018-09-13:07:30:01

BO_GL_BALANCE    BIN$dbh73KqhcaPgUNIKZRt4Cw==$0 TABLE        2018-09-13:06:30:01

BO_GL_BALANCE    BIN$dbelUmBFt1vgUNIKZRtubQ==$0 TABLE        2018-09-13:05:30:01

BO_GL_BALANCE    BIN$dbbOtaRqVnjgUNIKZRtlMA==$0 TABLE        2018-09-13:04:30:01

BO_GL_BALANCE    BIN$dX6mFn5o9j/gUNIKZRstqg==$0 TABLE        2018-09-10:09:30:01

CCBS_DOSLIG0     BIN$dbMFlTHMVSLgUNIKZRsvFw==$0 TABLE        2018-09-12:23:59:01

CCBS_DOSLIG0     BIN$dZ7ntL5oFzfgUNIKZRs2dw==$0 TABLE        2018-09-11:23:59:01

CCBS_DOSLIG0     BIN$dYrJ4zA1uUngUNIKZRs93Q==$0 TABLE        2018-09-10:23:59:01

DM_GLBALANCES    BIN$dbr/mSv/zwDgUNIKZRsVuw==$0 TABLE        2018-09-13:09:30:01

DM_GLBALANCES    BIN$dbopB1oKkt7gUNIKZRsMdA==$0 TABLE        2018-09-13:08:30:01

BO_GL_BALANCE    BIN$dbX4JLCOPIHgUNIKZRtRAg==$0 TABLE        2018-09-13:03:30:01

BO_GL_BALANCE    BIN$dbUhmQDELJXgUNIKZRtHyQ==$0 TABLE        2018-09-13:02:30:01

BO_GL_BALANCE    BIN$dbRLCJINaBTgUNIKZRs+kQ==$0 TABLE        2018-09-13:01:30:02

I checked alert log and no alerts.

Please advise.

Regards,

Joe