Home » RDBMS Server » Server Utilities » split partition in trigger (oracle 11gr2 solaris 10)
split partition in trigger [message #563589] Wed, 15 August 2012 10:35 Go to next message
guddu_12
Messages: 227
Registered: April 2012
Location: UK
Senior Member
Dear All,

Can i call split partition statement in after insert trigger, my scenerio is loader load the data in a table which is not scheduled, the my oracle jobs picks those data for further processing, table whic is being loaded by loader is partition and want to split the partition just after the data have been loaded.

Please advice
Re: split partition in trigger [message #563590 is a reply to message #563589] Wed, 15 August 2012 10:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>Can i call split partition statement in after insert trigger,
I give up.
Can you?
On the surface splitting partition from within any trigger does not seem to be a smart thing to do.
Re: split partition in trigger [message #563598 is a reply to message #563589] Wed, 15 August 2012 11:59 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot modify the object you are currently modifying (for instance, split a partition on the table you are currently loading).

But as you are in 11.2, you should use interval partitioning if you need such feature.

Regards
Michel
Previous Topic: Exporting using query parameter
Next Topic: how should i grant connect , resource privilege to a user (without DBA privilege)
Goto Forum:
  


Current Time: Thu Mar 28 09:40:14 CDT 2024