记录一下删除表分区的语句

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"

 

 

 

 

查询表的分区的信息:

 

-- 查询表的分区的信息:user_tab_partitions：

set wrap off
set linesize 1000
col partition_name for a15

spool E:/查询表的分区的信息_script009

select partition_name,high_value,tablespace_name
from user_tab_partitions
-- where table_name='Table_Name'
order by partition_position;

spool off

查看用户下有那些表使用了分区：

select * from user_tables a where a.partitioned='YES'

 

查看表使用的分区情况：

select * from user_tab_partitions where table_name='T_ALARM'