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: 172
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: 22515
Registered: January 2009
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: 58605
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: Mon Jul 28 18:00:46 CDT 2014

Total time taken to generate the page: 0.22272 seconds