ORA-31086: insufficient privileges to register schema “string” ORACLE 报错 故障修复 远程处理

文档解释

ORA-31086: insufficient privileges to register schema “string”

Cause: An attempt was made to register a schema without sufficient privileges.

Action: Make sure that the user has sufficient privileges to register the schema.

官方解释

常见案例

一般处理方法及步骤

1. 将用户授予 _EXECUTE_ANY_SCHEMA 权限:

grant execute any schema to ;

2. 重新尝试注册架构:

register schema oo(schema_name => ‘MY_SCHEMA’…);