My Oracle Support Banner

ORA-20001 Unable To Gather Schema Stats On Schema Names That Include Special Characters (Doc ID 3008692.1)

Last updated on MARCH 15, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.22.0.0.0 and later
Information in this document applies to any platform.

Goal

We have created some accounts for OS authentication and they have table objects however we get an error when executing the DBMS_STATS.GATHER_SCHEMA_STATS. Below is how we create the accounts and errors when gathering stats:

Solution

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
Goal
Solution


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