Partition insert trigger(Oracle 10g)
588495Aug 21 2007 — edited Aug 22 2007My table is partition on the basis of time.I am doing bulk uploading data on this table.will database provide follwing flexibility:
1.I want to create hourly partition ,can database create partition automatically when it finds new hour data is arrived or i have to make sure that before giving new hour data partition should be ready there.
2.If database does not give this facility to create partition automatically then i will be creating 24 partition for a day in advance now in this case does oracle give me trigger that data has arrived in new partition.(i mean not row trigger it should be only partition trigger.)let us say i have created 1,2,3,4....24 partition for the day in advance when i am inserting data in 1 and then when new data arrives for partition 2 then can database give me trigger when i can write code and rebuild index for partition 1 becuase now no more data for partition 1 will be coming.