My Oracle Support Banner

Getting ORA-20013 When Calling Ords.enable_schema (Doc ID 2785918.1)

Last updated on JULY 02, 2021

Applies to:

Oracle REST Data Services - Version 21.1.1 and later
Information in this document applies to any platform.

Symptoms

 In one Database, we try to call ords.enable_schema(...) on the ORDS_PUBLIC_USER schema as below and we get an error :

 

BEGIN
ORDS.ENABLE_SCHEMA(p_enabled => TRUE,
p_schema => 'ORDS_PUBLIC_USER',
p_url_mapping_type => 'BASE_PATH',
p_url_mapping_pattern => 'ORDS_PUBLIC',
p_auto_rest_auth => FALSE);
COMMIT;
END;
/

ORA-20013: Shcema or user is blacklisted: ORDS_PUBLIC_USER

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.