To record a statement that deletes a table partition

ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2007_10_1 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" p_tbl_alarm_2007_10_2 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2007_10_3 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" p_tbl_alarm_2007_11_1 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" p_tbl_alarm_2007_11_2 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" p_tbl_alarm_2007_11_3 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2007_12_1 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" p_tbl_alarm_2007_12_2 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2007_12_3 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_02_1 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" p_tbl_alarm_2008_02_2 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_02_3 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_03_1 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_03_2 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_03_3 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_04_1 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_04_2 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_04_3 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_05_1 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_05_2 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_05_3 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_06_1 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_06_2 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_06_3 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_07_1 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" p_tbl_alarm_2008_07_2 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_07_3 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_08_1 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" p_tbl_alarm_2008_08_2 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_08_3 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_09_1 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" p_tbl_alarm_2008_09_2 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_09_3 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_10_1 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" p_tbl_alarm_2008_10_2 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_10_3 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" p_tbl_alarm_2008_11_1 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" p_tbl_alarm_2008_11_2 ";
ALTER TABLE "Gisap". T_alarm "DROP PARTITION" P_tbl_alarm_2008_11_3 "

Information about the partition of the query table:

--Information about the partition of the query table: user_tab_partitions:

Set Wrap off
Set Linesize 1000
Col Partition_name for A15

Spool e:/information about the partition of the query table _script009

Select Partition_name,high_value,tablespace_name
From User_tab_partitions
-Where table_name= ' table_name '
Order BY Partition_position;

Spool off

View those tables under the user that use partitions:

SELECT * from User_tables a where a.partitioned= ' YES '

To view the partition used by a table:

SELECT * from user_tab_partitions where table_name= ' T_alarm '