Home » SQL & PL/SQL » SQL & PL/SQL » Table partitioning (Oracle 9i)
Table partitioning [message #320467] Thu, 15 May 2008 03:39 Go to next message
psathya30
Messages: 4
Registered: May 2008
Junior Member
Hi ,
A table is partitioned on a date column. 6 partitions with one partition for a month. At the end of every month , new partition for next month is created and the old one is dropped. We are doing this manually using OEM. How can this process be automated?


Thanks,
Sathya
Re: Table partitioning [message #320474 is a reply to message #320467] Thu, 15 May 2008 04:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use a script with ALTER TABLE statements.
Or migrate to 11g and use INTERVAL partitioning.

Regards
Michel
Re: Table partitioning [message #320771 is a reply to message #320474] Fri, 16 May 2008 03:47 Go to previous message
psathya30
Messages: 4
Registered: May 2008
Junior Member
Thanks Michel.
Previous Topic: Bulk insert
Next Topic: performance of procedures
Goto Forum:
  


Current Time: Sun Dec 04 22:36:24 CST 2016

Total time taken to generate the page: 0.10706 seconds