Siebel Open UI, Tools, Scripting and EAI (MOSC)

MOSC Banner

Unique index for extension column in S_PER_COMM_ADDR

edited Jan 22, 2020 4:00AM in Siebel Open UI, Tools, Scripting and EAI (MOSC) 7 commentsAnswered

There was a requirement to make unique Index on S_PER_COMM_ADDR with a custom column X_UNIQUE_EMAIL since we were not able to create the same from siebel tools

it was done at DB level . Unique constraint automatically created unique index.

Is there any way to create unique index on custom columns using siebel tools . The reason is because whenever we perform ddlsync it gives error because of this mismatch and if we want any future modification on this table it has to be done at database level

I know oracle doesnt recommend creating custom unique index is there a workaround using integration component or something else ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

SBL Configuration-EAI Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center