今天一客户说在做impdp导入时，报错Ora-28031。我们看看ora-28031的报错是什么意思：
|
1 2 3 |
ORA-39083: Object type OBJECT_GRANT failed to create with error: ORA-31625: Schema SYS is needed to import this object, but is unaccessible ORA-28031: maximum of 148 enabled roles exceeded |
从报错信息看，是SYS用户的role超过148个，一开始，我们用
|
1 |
select count(*) from dba_role_privs where grantee = 'SYS'; |
[…]