-
hello,
Iam using Oracle 8i personel database on Win NT .
when i fire a command it gives error
SVRMGRL> DROP USER SCOTT CASCADE;
ora-00604 error occrued at recursive SQL level 1
ora-00949 table view does not exits
ora-06512 at line 7
-
sqlplus "/ as sysdba"
alter session set events '10046 trace name context forever, level 12';
DROP USER SCOTT CASCADE;
exit;
go to your udump and look for the trace file and see what it says
look your alert in bdump
look trace file generated by 00604 in udump
-
Actually this is a well-known bug ... Support will be able to help you .. involves running one of the $ORACLE_HOME/RDBMS/Admin scripts .. catnoque.sql I think.
The problem is due to the user having acquired Temporary segments that are not released properly ... doesn't happen if using proper Temporary tablespace tempfiles on 8i +.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|