牧海归来

SQL:alter table abcsplit partition abc_201402 at (to_date('201402','yyyymm')) into (partition abc_201403,partition abc_201404);注释：abc_201402是表abc的一个已经建好的的分区表，一声SQL会将分区表abc_201402拆分成abc_2

select count(1) from user_objects where object_type = 'PROCEDURE'select count(1) from user_objects where object_type = 'INDEX'select count(1) from user_objects where object_type = 'VIEW'select c

select * from user_ind_columns where table_name = upper('agent_master')  // agent_master为表名创建主键：ALTER TABLE QC_MASTER ADD  PRIMARY KEY (AGENT_CODE);的时候oracle会自动创建索引，如果再次在改主键对应的自动创建索引会报错。用u