OraFAQ Forum: SQL & PL/SQL » Reference Partitioning

Home » SQL & PL/SQL » SQL & PL/SQL » Reference Partitioning (Oracle 11g)

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

Reference Partitioning [message #634639]

Thu, 12 March 2015 07:34

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Hi,

we have a parent table already created with range partitions. Also, child table is created but without any partitions.
Can we add reference partitioning to existing child table? Please advise.

If Yes, please provide any example.

Regards,
SRK

Report message to a moderator

Re: Reference Partitioning [message #634640 is a reply to message #634639]

Thu, 12 March 2015 07:40

John Watson
Messages: 9003
Registered: January 2010
Location: Global Village

Senior Member

No. You'll have to recreate the table. It's no big deal, just do it with dbms_redefinition.

Report message to a moderator

Re: Reference Partitioning [message #634685 is a reply to message #634640]

Fri, 13 March 2015 02:53

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Thanks a lot.

Report message to a moderator

Previous Topic:	How to Exclude Locked Rows from Select
Next Topic:	2 count query results manipulation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Aug 26 09:40:28 CDT 2026