Database Administration (MOSC)

MOSC Banner

SYS.DAM_CONFIG_PARAM$ & SYS.TSDP_POLICY$, has duplicate rows and index unsable post linux migration.

edited Feb 19, 2019 11:57AM in Database Administration (MOSC) 2 commentsAnswered

We did Database migration from AIX to Liunx move for 12.1 Database using TTS for Oracle EBS.

Following doc id was used for the same "(Doc ID 1945814.1)'

Everything looks good except for following INDEXS are in UNUSABLE state:

owner   index_name  t                        able_name stauts

------------------------------------------------------

SYS  I_DAM_CONFIG_PARAM$            DAM_CONFIG_PARAM$ UNUSABLE

SYS  TSDP_POLICY$PK                       TSDP_POLICY$ UNUSABLE

SYS  TSDP_POLICY$UK                    TSDP_POLICY$ UNUSABLE

SYS  TSDP_SUBPOL$PK                   TSDP_SUBPOL$ UNUSABLE

==============================

On checking the table:

SYS.TSDP_POLICY$ - saw duplicate rows:

1 REDACT_AUDIT 0

1 REDACT_AUDIT 0

SYS.DAM_CONFIG_PARAM$   count(*) - 28 on linux db box, compared to  - 14 on aix.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center