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

Report message to a moderator

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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use a script with ALTER TABLE statements.
Or migrate to 11g and use INTERVAL partitioning.

Regards
Michel

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Bulk insert
Next Topic: performance of procedures
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 06 17:11:48 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.