我在用數(shù)據(jù)泵導(dǎo)入數(shù)據(jù)的時候報(bào)的錯

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 --以下內(nèi)容自動執(zhí)行

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. 賦予權(quán)限
SQL> grant plustrace to dba with admin option;

Grant succeeded.

4.進(jìn)行查看

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

ROLE PASSWORD AUTHENTICAT
------------------------------ -------- -----------
PLUSTRACE NO NONE

轉(zhuǎn)載于:https://www.cnblogs.com/zy-303/p/9525898.html

總結(jié)

以上是生活随笔為你收集整理的ORA-01919: role 'OLAPI_TRACE_USER' does not exist的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。