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
Re: Oracle Partitioning [message #343777 is a reply to message #343768] Thu, 28 August 2008 02:13 Go to previous message
Michel Cadot
Messages: 64103
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:
http://www.dba-village.com/dba/village/dvp_forum.OpenThread?ThreadIdA=24757

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


Current Time: Sat Dec 03 10:07:16 CST 2016

Total time taken to generate the page: 0.14105 seconds