Hi,
11.2.0.3 version
Noticed a sql we have was returning an error
dropped table concerned but look slike the old partitiosn are still in user_tab_partitions
BIN$rJuJTsqdAJjgUwq+RCb6SA==$0
Could change the code such that ignores bin tables but don't understand why partitions not dropped if table itself dropped?
Can selected bin tables be dropped in user_tab_partitions
Even though the table isn't in the tables listed in our_control_tables it looks like it is evaluating the where condition first
select *
from user_tab_partitions a,
our_control_tables b,
where a.table_name = b.table_name
and to_number(replace(a.partition_name,'PTION_RUNNUM_','')) = 3575
Thanks