My Oracle Support Banner

Deleted Statistics For Column:WF_USER_ROLE_ASSIGNMENTS in the DB Alert log After Upgrading the Database to 12 C (Doc ID 2257444.1)

Last updated on FEBRUARY 13, 2019

Applies to:

Oracle Workflow - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3

After migrating 11gR2 DB from Linux to AIX ( 12c ) using transportable tablespaces method -
Now see following messages in DB alert.log after migration


ERROR
-----------------------

Deleted statistics for column:
SYS_STSANI#Z5CVOXUIE8I#880KGGY
of [sub]partition PQH_ROLE of table WF_USER_ROLE_ASSIGNMENTS
Deleted statistics for columns:
SYS_STSRQSM3$QAS3ZI4T0LUI3FRNN,
SYS_STS5YEACF8P2L5##_D1TPLE#Y7
of [sub]partition ENG_LIST of table WF_LOCAL_USER_ROLES
Deleted statistics for column:
SYS_STSANI#Z5CVOXUIE8I#880KGGY
of [sub]partition ENG_LIST of table WF_USER_ROLE_ASSIGNMENTS
Mon Apr 17 14:15:28 2017


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Occurs after migrating 11gR12  DB from Linux to AIX ( 12c ) using transportable tablespaces - method


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.