ORA-00600: internal error code, arguments: [kkpoStateObject], [3], [], [], [], [

[cuizhou5876]

ORA-600 [kkpoStateObject] for CREATE AS SELECT [ID 472451.1]


Modified 30-APR-2008 Type PROBLEM Status MODERATED
In this Document
Symptoms
Changes
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.
Applies to:

Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 10.2.0.3
This problem can occur on any platform.
Symptoms

Receiving ORA-00600: internal error code, arguments: [kkpoStateObject] During Create Table As Select Statement .

-For 9i database the error could be reported as follow :
ORA-600 [4814], [5]
Changes

-Policies enabled for the table using DBMS_RLS package .
Cause

The issue is related to Bug 2274295 still in the development stage .

Solution

-- To implement the solution, please execute the following steps::
1-
Use the following query to find the policies for user <user name> that is configured for Table
<table name>

SQL> select object_owner, object_name, policy_name
from dba_policies
where object_name='<table name>'
and object_owner='<user name>';


2-
Disable the policies returned from the previous query as follow :
SQL>exec dbms_rls.enable_policy (<owner name>, <table name>,<policy name >, FALSE) ;

For e.g.
SQL> exec dbms_rls.enable_policy('SCOTT','JOBS','My_Policy',FALSE);



3-
Retry to create the table as select as follow :

SQL>conn SCOTT / <password>
SQL>create table NEW_table as select * from jobs ;
References

BUG:2274295 - ORA-600 [4814], [5],


Related
Products
Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
Errors
ORA-600[4814]; ORA-600[KKPOSTATEOBJECT]

[ngx20080110]

600一般很難，要向Oracle support尋求支持

[minitoy]

贴的里面不是有解决方案么？

[minitoy]

1-
Use the following query to find the policies for user <user name> that is configured for Table
<table name>

SQL> select object_owner, object_name, policy_name
from dba_policies
where object_name='<table name>'
and object_owner='<user name>';


2-
Disable the policies returned from the previous query as follow :
SQL>exec dbms_rls.enable_policy (<owner name>, <table name>,<policy name >, FALSE) ;

For e.g.
SQL> exec dbms_rls.enable_policy('SCOTT','JOBS','My_Policy',FALSE);



3-
Retry to create the table as select as follow :

SQL>conn SCOTT / <password>
SQL>create table NEW_table as select * from jobs ;

[心中的彩虹]

[Quote=引用楼主 cuizhou5876 的回复:]
ORA-600 [kkpoStateObject] for CREATE AS SELECT [ID 472451.1]


Modified 30-APR-2008 Type PROBLEM Status MODERATED
In this Document
Symptoms
Changes
Cause
Solution
References

Th……
[/Quote]

BUG:2274295 - ORA-600 [4814], [5], 升级吧