My Oracle Support Banner

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

Last updated on FEBRUARY 22, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.