Dear Experts
I am unable to drop a partition that is created after performing exchange table in the history table.
select * from user_tab_partition
where table_name='TB_HIST';
Partition name is created like :
partition_name
090422
100422
110422
Whenever I try to drop partition by using the below syntax
alter table tran_hist drop partition 090422;
The error I am getting:
ORA-14108: illegal partition-extended table name syntax
Please help.