Drop table error. - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Drop table error.

Drop table error.# Database - 数据库

s*m2002-04-24 07:04

1 楼

Hi,
I have my Oracle 8.1.7 installed on RH7.2. I choose to create a typical
database during installation process. Then i create an user 'ME'. I login as
ME through sqlplus on local machine where database resides. Then i create a
table. I can insert delete data into and from the table. However, when i try
to drop it, i get this error
############
ERROR at line 1:
ORA-04098: trigger 'SYS.JIS$ROLE_TRIGGER$' is invalid and failed re-validation
#################
Can someone help me?
Thanks.

a*c2002-04-24 07:04

2 楼

You can recompile this trigger.
Connect AS SYSDBA or connect internal
SQL> ALTER TRIGGER . COMPILE ;
Hope it would help.

re-validation

【在 s***m 的大作中提到】

: Hi,
: I have my Oracle 8.1.7 installed on RH7.2. I choose to create a typical
: database during installation process. Then i create an user 'ME'. I login as
: ME through sqlplus on local machine where database resides. Then i create a
: table. I can insert delete data into and from the table. However, when i try
: to drop it, i get this error
: ############
: ERROR at line 1:
: ORA-04098: trigger 'SYS.JIS$ROLE_TRIGGER$' is invalid and failed re-validation
: #################

c*d2002-04-24 07:04

3 楼

check the user privilege to make sure u enabled that user to drop the table.

re-validation

【在 s***m 的大作中提到】

a*c2002-04-24 07:04

4 楼

Surely user can drop the tables created by user self. I think user 'ME' does
have the drop privilege. :)

as
a
try

【在 c***d 的大作中提到】

: check the user privilege to make sure u enabled that user to drop the table.
:
: re-validation

c*d2002-04-24 07:04

5 楼

hmm. u r rite. that error is kind of wierd. i think u may need to recompile
the trigger by alter trigger etc..

table.
typical
login
create

【在 a****c 的大作中提到】

: Surely user can drop the tables created by user self. I think user 'ME' does
: have the drop privilege. :)
:
: as
: a
: try