Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating a new index on gl_code_combinations table

ChezJun 6 2018 — edited Jun 8 2018

Hi Guru's

I have a need to build a new index based on segment1, segment4 and segment5 of the accounting key structure which of course is segment1, segment4 and segment5 of the gl_code_combinations table. This table however is indexed on code_combination_id. I need the index to be based on a combination of segment1, segment4 and segment5 as stated.

How can I achieve this?

We are operating in a cloud environment and not EBS.

Please help.

Regards

Tam

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 6 2018
Added on Jun 6 2018
#sql-developer
3 comments
549 views