Issue with trunacating the partitions of a table.
Hello all,
I have a partitioned table called temp1_list_cmpgn_hist_dtl and it is partitioned by month(campaign_start_date).
Queries I tried,
TRUNCATE TABLE temp1_list_cmpgn_hist_dtl PARTITION t_list_cmpgn_201006
TRUNCATE TABLE temp1_list_cmpgn_hist_dtl PARTITION t_list_cmpgn_201006 REUSE STORAGE
but it is throwing me the following error:
SQL Error: ORA-03291: Invalid truncate option - missing STORAGE keyword
03291. 00000 - "Invalid truncate option - missing STORAGE keyword"
*Cause: Expected STORAGE keyword
*Action: Either specify DROP STORAGE or REUSE STORAGE
Also, I am trying to find the partition_name for the table 'temp1_list_cmpgn_hist_dtl' but it is not showing any partitions though there are partitions.
I tried the query,
SELECT partition_name from user_tab_partitions WHERE table_name = 'temp1_list_cmpgn_hist_dtl'.
Thx,
Shank.