Re: ORA-600 when splitting partitions on IOT's from within PL/SQL

oracle 600 error, its normally a bug.

joe
Diana Duncan wrote:
>
> Oracle 8.1.6 32-bit on Solaris 2.7
>
> Anyone seen this one? If I do an execute immediate (or dbms_sql) from
> PL/SQL to split the partition on the index-organized table, I get the error.
> If I run the statement from SQL, no error. Splitting the partitions on
> regular tables have no problems. The alert log and associated trace file
> have no more helpful information that I can see.
>
> set serverout on
> begin
> dbms_output.enable(900000);
> domainTrigPkg.createPartitions(1007);
> end;
> /
> alter table DOMAIN_FUNCTIONALITY_ASC add partition acct1007 values less than
> (1008) tablespace
> acct1007_data
> Partition exists, splitting....
> alter table DOMAIN_FUNCTIONALITY_ASC split partition acct1008 at (1008) into
> (partition acct1007
> tablespace acct1007_data, partition acct1008 tablespace acct1008_data)
> begin
> *
> ERROR at line 1:
> ORA-00600: internal error code, arguments: [604], [ctcicttb], [], [], [],
> [], [], []
> ORA-06512: at "FILEFRENZY.DOMAINTRIGPKG", line 219
> ORA-14074: partition bound must collate higher than that of the last
> partition
> ORA-06512: at line 3
>
> SQL> alter table DOMAIN_FUNCTIONALITY_ASC split partition acct1008 at (1008)
> into (partition acct100
> 7
> 2 tablespace acct1007_data, partition acct1008 tablespace acct1008_data)
> 3 /
>
> Table altered.
>
> Diana Duncan
> Database Architect
> fileFrenzy.com
> diana_at_filefrenzy.com
> 919.833.1766 x 238
>
> --
> Author: Diana Duncan
> INET: Diana_at_fileFRENZY.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Joe Testa  http://www.oracle-dba.com
Oracle 8i documentation online http://www.oracle-dba.com/oracle-docs