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

From: Diana Duncan <Diana_at_fileFRENZY.com>
Date: Wed, 16 Aug 2000 18:11:16 -0400
Message-Id: <10591.114787@fatcity.com>

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 Received on Wed Aug 16 2000 - 17:11:16 CDT