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: Fri Jul 28 04:04:57 CDT 2017

Total time taken to generate the page: 0.11024 seconds