Thanks for the question, abdullah.
Asked: June 07, 2017 - 11:32 am UTC
Last updated: June 07, 2017 - 11:43 am UTC
Version: 11G
Viewed 1000+ times
You Asked
Hi
We have recently created a new database from an existing database via RMAN incremental backup level 1.
We have created a user and provided all the privileges to it.
But, we are currently facing an issue, we are unable to drop any tables from that database.
drop table REPT_SUPPLIER_COUNT_tbd;
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 512
ORA-29283: invalid file operation
ORA-06512: at line 8
and Connor said...
I suspect you have a DDL trigger somewhere, which is trying to write something out to a file (eg an audit trail), and that trigger is failing.
Try
select *
from dba_triggers
where table_name is null
and see what comes back
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment