Oracle dynamically establishes partitioned tables

Because there is too much data to speed up retrieval

To build a table as a partitioned table

Adding temporary tables dynamically when data is inserted

 as  --Local variables hereFq_dmvarchar( -); P_count Number; --p_fadm number;P_sqlvarchar( -);begin  --Test Statements here  --querying all partitions of Zkz--SELECT partition_name from user_tab_partitions WHERE table_name= ' ZHZ_MN_FQ ';FQ_DM:='ZHZ_MN_FQ'||P_FA_DM;--Partition name     Select Count(*) intoP_count fromUser_tab_partitionsWHEREtable_name='ZKZ_MN_FQ'  andPartition_name=FQ_DM; ifP_count=0  Then --if the partition does not exist, this creates the partitionP_sql:='ALTER TABLE ZKZ_MN_FQ add partition'||Fq_dm||'VALUES ('||P_fa_dm||') tablespace USERS'; Executeimmediate p_sql; End if; Insert  intoMn_fqValues(p_zh,p_k_id, P_z, P_BM, P_xq, P_DQ, P_FA_DM); Commit;