sysautomation
asked on
Oracle - Unlimited Tablespace (error ORA-00600)
Hello
I am using Oracle XE 11G (no Oracle support, I know). CentOS 6.5 64bit
I am getting following error when I create a user, add/import some data and try to drop it:
To reproduce at my machine I do:
But when I run following I am able to drop my user without a problem:
History:
Some DBA working in past some months ago executed following:
It was revoked after a few months by:
I would be really thankful if someone can help me fix this issue.
Thanks in advance,
Habib
I am using Oracle XE 11G (no Oracle support, I know). CentOS 6.5 64bit
I am getting following error when I create a user, add/import some data and try to drop it:
SQL> drop user test_user cascade;
drop user test_user cascade
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kdddgb:clsviol_kcbgcur_9], [0],
[4194452], [1], [4294967250], [8192], [], [], [], [], [], []
To reproduce at my machine I do:
CREATE USER TEST_USER IDENTIFIED BY TEST_PASSWORD
DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP
QUOTA 200M ON USERS;
GRANT CREATE TRIGGER, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, CREATE VIEW,
CREATE TYPE, CREATE SESSION, CREATE MATERIALIZED VIEW , CREATE PROCEDURE TO TEST_USER;
ALTER USER TEST_USER GRANT CONNECT THROUGH apex_rest_public_user;
GRANT EXECUTE ON UTL_HTTP TO TEST_USER;
GRANT EXECUTE ON UTL_SMTP TO TEST_USER;
GRANT EXECUTE ON UTL_TCP TO TEST_USER;
GRANT EXECUTE ON DBMS_CRYPTO TO TEST_USER;
imp test_user/TEST_PASSWORD file=MyDUmp.dmp fromuser=pageh touser=test_user
SQL> drop user test_user cascade;
drop user test_user cascade
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kdddgb:clsviol_kcbgcur_9], [0],
[4194452], [1], [4294967250], [8192], [], [], [], [], [], []
grant unlimited tablespace to test_user;
But when I run following I am able to drop my user without a problem:
SQL> grant unlimited tablespace to test_user;
Grant succeeded.
SQL> drop user test_user cascade;
User dropped.
History:
Some DBA working in past some months ago executed following:
grant unlimited tablespace to public;
It was revoked after a few months by:
revoke unlimited tablespace from public;
I would be really thankful if someone can help me fix this issue.
Thanks in advance,
Habib
ORA-00600:http://ora-00600.ora-code.com/
internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
Cause: This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition.
Action: Report as a bug - the first argument is the internal error number
ASKER
If you please read my question I am using XE and Oracle does not provide support for that. Therefore contacting Oracle support is out of question here.
Afraid I cannot offer any other advice, deciphering kdddgb:clsviol_kcbgcur_9 into something intelligible is something that only Oracle support can do (to my knowledge).
And, as I said earlier, this message will be consistent, even the formal wording of the error message says report a bug.
And, as I said earlier, this message will be consistent, even the formal wording of the error message says report a bug.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
One other option you could try: log in as the user you want to drop, then run this query:
select 'drop '||object_type||' '||object_name||';' "Command"
from user_objects where object_type not in ('INDEX', 'INDEX PARTITION', 'LOB', 'TABLE PARTITION');
Or, from a DBA-privileged account, run the query like this:
select 'drop '||object_type||' '||owner||'.'||object_name ||';' "Command"
from user_objects where object_type not in ('INDEX', 'INDEX PARTITION', 'LOB', 'TABLE PARTITION');
Then, in either case, run the resulting commands, and try the "drop user..." command again after that.
select 'drop '||object_type||' '||object_name||';' "Command"
from user_objects where object_type not in ('INDEX', 'INDEX PARTITION', 'LOB', 'TABLE PARTITION');
Or, from a DBA-privileged account, run the query like this:
select 'drop '||object_type||' '||owner||'.'||object_name
from user_objects where object_type not in ('INDEX', 'INDEX PARTITION', 'LOB', 'TABLE PARTITION');
Then, in either case, run the resulting commands, and try the "drop user..." command again after that.
do you know what is in the dump file?
Are there any errors in the import log?
You're using the old imp.
Could you export again from the source system using expdp and then import with impdp as described above?
Are there any errors in the import log?
You're using the old imp.
Could you export again from the source system using expdp and then import with impdp as described above?
See:
https://www.experts-exchange.com/questions/27252809/ORA-00600.html?anchorAnswerId=ccepted-solution#accepted-solution
https://www.experts-exchange.com/questions/27644063/Oracle-ora-00600.html?anchorAnswerId=ccepted-solution#accepted-solution
You will find this advice is quite consistent for ORA-00600