Home » SQL & PL/SQL » SQL & PL/SQL » Automating adding partitions by using data dictionary
Automating adding partitions by using data dictionary [message #192830] Wed, 13 September 2006 16:43
shankarr_p
Messages: 1
Registered: September 2006
Location: India
Junior Member

Hi,

I want to automate addition of partitions (range,list) .We use lot of partitions,some of which monthly,some quarterly,half yearly etc.I want to pick data from dba_tab_partions and generate generic script to create next partitons automatically.Is it possible,if any body done it,please let me know how did you do that.We have to pick namimg convention and frequency of adding partition from data dictionary.

Thanks
Shankar
Previous Topic: Grouping records based on time (every 5 minutes)
Next Topic: Hierarchical View of Query
Goto Forum:
  


Current Time: Wed Dec 07 18:41:21 CST 2016

Total time taken to generate the page: 0.06722 seconds