All Forums General
Purushotham 87 posts Joined 04/14
01 Jul 2014
could anyone please tell me can we alter a join index table

Hi Everyone,

Could anyone pls tell me can we alter a join index table or hash index table?
Regards,
Purushotham.

Purushotham.M
Purushotham 87 posts Joined 04/14
03 Jul 2014

Hi raja and dnoeth,

Please share me, can we alter the join index table and hash index table.
Thanks in advance.
Regards,
Purushotham.

Purushotham.M

mikesteeves 46 posts Joined 10/11
03 Jul 2014

I believe you'll have to drop the Join Index before you can alter the table on which the JI is built.

Purushotham 87 posts Joined 04/14
03 Jul 2014

Hi Mikesteeves,

Not base table.I want to add columns to join index table by using
Alter join index join index-name add columns. Can we do alter on join index table without droping the join index table.

Regards,
Purushotham.

Purushotham.M

mikesteeves 46 posts Joined 10/11
03 Jul 2014

I believe the ALTER will not work on the JI.  You'll most likely have to drop the JI is you wish to change its structure.
 

Purushotham 87 posts Joined 04/14
03 Jul 2014

Thanks a lot....mikesteeves.
Regards,
Purushotham.

Purushotham.M

Purushotham 87 posts Joined 04/14
03 Jul 2014

Hi mikestevees,

Could you pls tell me why join index does not support Unique primary index?

Purushotham.M

Gyanendra 10 posts Joined 03/11
07 Aug 2014

Hi Purushotham,
Join index support UPI. Please tell me if you are getting any error while defining UPI on join index.

You must sign in to leave a comment.