could anyone please tell me can we alter a join index table

General
Enthusiast

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.
7 REPLIES
Enthusiast

Re: could anyone please tell me can we alter a join index table

Hi raja and dnoeth,

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

Re: could anyone please tell me can we alter a join index table

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

Enthusiast

Re: could anyone please tell me can we alter a join index table

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.
Enthusiast

Re: could anyone please tell me can we alter a join index table

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.

Enthusiast

Re: could anyone please tell me can we alter a join index table

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

Re: could anyone please tell me can we alter a join index table

Hi mikestevees,

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

Re: could anyone please tell me can we alter a join index table

Hi Purushotham,

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

Gyan