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
Messages: 1
Registered: September 2006
Location: India
Junior Member


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.

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

Current Time: Tue Apr 25 08:00:01 CDT 2017

Total time taken to generate the page: 0.27802 seconds