ORA-01919: role 'OLAPI_TRACE_USER' does not exist

我在用数据泵导入数据的时候报的错

TEST_USER1@ORCL> conn / as sysdba

SYS@ORCL> grant plustrace to TEST_USER1;

grant plustrace to TEST_USER1

*

ERROR at line 1:

ORA-01919: role 'PLUSTRACE' does not exist

SYS@ORCL> select * from dba_roles where role='PLUSTRACE';

no rows selected

2、 建立角色

SYS@ORCL>@?/sqlplus/admin/plustrce.sql --以下内容自动执行

SQL>

SQL> drop role plustrace;

drop role plustrace

*

ERROR at line 1:

ORA-01919: role 'PLUSTRACE' does not exist

SQL> create role plustrace;

Role created.

SQL>

SQL> grant select on v_$sesstat to plustrace;

Grant succeeded.

SQL> grant select on v_$statname to plustrace;

Grant succeeded.

SQL> grant select on v_$mystat to plustrace;

Grant succeeded.

3. 赋予权限

SQL> grant plustrace to dba with admin option;

Grant succeeded.

4.进行查看

SQL> select * from dba_roles where role='PLUSTRACE';

ROLE PASSWORD AUTHENTICAT

------------------------------ -------- -----------

PLUSTRACE NO NONE