Oracle Solution for Error ora-29938

ORA-29938: both indextype and statistics type should be system-managed

What triggered the Error:

Either an ASSOCIATE STATISTICS WITH SYSTEM MANAGED STORAGE TABLES command was issued with an indextype which is not system-managed, or an ASSOCIATE STATISTICS command was issued with an indextype which is system-managed.

What should we do to fix it:

Check to see if both indextype and statistics type are implemented with system-managed storage tables.