OraFAQ Forum: SQL & PL/SQL » how to add mautiple partition on a table.

Home » SQL & PL/SQL » SQL & PL/SQL » how to add mautiple partition on a table. (oracle 10g )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to add mautiple partition on a table. [message #616651]

Thu, 19 June 2014 05:23

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

I have a table call_details. There are two columns :- call_type , call_duration
I have added partition by list(call_type) on a table
Now my requirement is I want to add partition by range(call_duration) on a same table.
Is it possible and if yes then how to do that.
Thanks

Report message to a moderator

Re: how to add mautiple partition on a table. [message #616654 is a reply to message #616651]

Thu, 19 June 2014 05:29

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Sounds like you want subpartitions:
http://docs.oracle.com/cd/E11882_01/server.112/e25523/part_admin001.htm#i1006655

Report message to a moderator

Re: how to add mautiple partition on a table. [message #616667 is a reply to message #616651]

Thu, 19 June 2014 07:11

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

You cannot create LIST-RANGE composite partitioning in 10g. It was introduced with 11g Release 1. Prior to this only Range-Hash and Range-List was possible.

Report message to a moderator

Previous Topic:	Help required for Query
Next Topic:	ORA-01003: no statement parsed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 21:51:14 CDT 2024