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
Messages: 74
Registered: November 2007
Location: mumbai
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,,

Re: Oracle Partitioning [message #343777 is a reply to message #343768] Thu, 28 August 2008 02:13 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In the following link you will find an example of how to use a cycle partitioning:

Previous Topic: previously word
Next Topic: why cant we insert data, or alter dual table?
Goto Forum:

Current Time: Sun Aug 20 19:59:08 CDT 2017

Total time taken to generate the page: 0.01425 seconds