1:使用wonder用户登录,创建过程,wonder用户有dba权限,过程所做的任务是截断以及删除video用户下的分区表,以及增加一个新分区
CREATE OR REPLACE PROCEDURE DEL_ADD_PARTITION
(LTIME VARCHAR2,NTIME VARCHAR2,N1TIME VARCHAR2
)
AS
BEGIN
--截断与删除视频分区表
/*
EXECUTE IMMEDIATE 'ALTER TABLE VIDEO.EXT_VST_SP TRUNCATE PARTITION P_VST_'||LTIME;
EXECUTE IMMEDIATE 'ALTER TABLE VIDEO.EXT_VST_SP DROP PARTITION P_VST_'||LTIME;
EXECUTE IMMEDIATE 'ALTER TABLE VIDEO.EXT_DWN_SP TRUNCATE PARTITION P_DWN_'||LTIME;
EXECUTE IMMEDIATE 'ALTER TABLE VIDEO.EXT_DWN_SP DROP PARTITION P_DWN_'||LTIME;
EXECUTE IMMEDIAT