Home » RDBMS Server » Server Administration » Spliting table partition without making the primary key index UNUSABLE (Oracle RDBMS 11.2.0.3, HP-Ux B.11.31)
Spliting table partition without making the primary key index UNUSABLE [message #581527] Mon, 08 April 2013 10:40 Go to next message
samg4ug
Messages: 33
Registered: July 2007
Location: India
Member
Dear Friends,

Please help me with the command for splitting a table partition without making its primary key index ar any other indexes unusable.
I think it is possible to do so 10g onwards.

DB Details:

Oracle RDBMS 11.2.0.3, HP-Ux B.11.31, OLTP

Thanking you.

Regards,
Soumitra G
Re: Spliting table partition without making the primary key index UNUSABLE [message #581533 is a reply to message #581527] Mon, 08 April 2013 11:11 Go to previous messageGo to next message
Michel Cadot
Messages: 59203
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALTER TABLE ... SPLIT PARTITION ... UPDATE INDEXES;

Regards
Michel

[Updated on: Mon, 08 April 2013 11:12]

Report message to a moderator

Re: Spliting table partition without making the primary key index UNUSABLE [message #581534 is a reply to message #581533] Mon, 08 April 2013 11:16 Go to previous message
samg4ug
Messages: 33
Registered: July 2007
Location: India
Member
Dear Michel,

Thanks for your quick reply.

Regards,
Soumitra G
Previous Topic: Error 119 and ERROR 130
Next Topic: Single Port for Database
Goto Forum:
  


Current Time: Tue Sep 23 17:33:39 CDT 2014

Total time taken to generate the page: 0.09091 seconds