Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Partitioning (win Xp, Oracle 10g)
Oracle Partitioning [message #343768] Thu, 28 August 2008 01:58 Go to next message
freakabhi
Messages: 74
Registered: November 2007
Location: mumbai
Member
HI all,

I want to make partitioning on the table, keys would be Year and month , so can anybody suggest me what would be right partitioning m/d like Range, List.

one more req, we have is :

I need to keep at most 12 partiton as per the latest month,year....every month new will be created and oldest will be deleted...so how to get this done,,,any idea for this,,


thanks,
freakabhi

Report message to a moderator

Re: Oracle Partitioning [message #343777 is a reply to message #343768] Thu, 28 August 2008 02:13 Go to previous message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
In the following link you will find an example of how to use a cycle partitioning:
http://www.dba-village.com/dba/village/dvp_forum.OpenThread?ThreadIdA=24757

Regards
Michel

Report message to a moderator

Previous Topic: Materialized View
Next Topic: Difference between two dates
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 14 12:22:43 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.