Siebel System Admin, Install and Upgrade (MOSC)

MOSC Banner

Siebel Upgrade Impact /9 now Defaults to Y 22.10 Create Desc Indexes by Default Now

in Siebel System Admin, Install and Upgrade (MOSC) 1 commentAnswered

Hi All,

We are just running a Siebel upgrade on a really large dev database that is a copy of production.

I am monitoring progress and see a ton of huge indexes getting recreated. This customer does not any existing descending indexes. Since the customer does not have any descending indexes we did not add /9 Y to tell ddlimp to support descending Oracle indexes like we normally do if the customer does have descending indexes.

Just ran ddlimp -help and now see after all these years of /9 defaulting to N it now defaults to Y.

Think this is going to cause some unexpected slowness for Siebel customers so wanted to pass this along.

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 Sys Admin 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