User_tab_columns Contains Dropped Tables After Purge Recyclebin (Doc ID 1345785.1)

Last updated on DECEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 29-DEC-2016***

Symptoms


USER_TAB_COLUMNS is showing dropped tables while USER_TABLES is not:


select table_name from user_tab_columns where table_name like 'BIN%' and rownum < 10;




TABLE_NAME
------------------------------
BIN$qYcRuNHtANLgQ8gsAnQA0g==$0
BIN$qYcRuNHtANLgQ8gsAnQA0g==$0
BIN$qYcRuNHtANLgQ8gsAnQA0g==$0
BIN$qYcPvfUlAYLgQ8gsAnQBgg==$0
BIN$qYcPvfUlAYLgQ8gsAnQBgg==$0
BIN$qYcPvfUlAYLgQ8gsAnQBgg==$0
BIN$qYcPvfUlAYLgQ8gsAnQBgg==$0
BIN$qYcPvfUlAYLgQ8gsAnQBgg==$0
BIN$qYcPvfUlAYLgQ8gsAnQBgg==$0

9 rows selected



SQL> select table_name,partition_name from user_tab_partitions where table_name like 'BIN%';



no rows selected




SQL> select table_name from user_tables where table_name like 'BIN%';



no rows selected

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms