Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL*Loader-605: Non-data dependent ORACLE error -- load discontinued

666246Jul 7 2010 — edited Jul 9 2010

Hi,

I have tried to load a 11.4GB .tbl file into PARTSUPP table of TPCH but i got this error:

SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued.

I've checked the table, 73339625 rows are inserted into PARTSUPP table. After searching for it, i came to know that I have to increase tablespace size or data file size. Now I'm trying to increase the datafile size but I'm not able to do it.

SQL> alter database datafile 'G:\KAM\T4K01.DBF' resize 80000M;
alter database datafile 'G:\KAM\T4K01.DBF' resize 80000M
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcbgcur_9], [0], [4282756], [1], [4294967250], [8192], [], []
ORA-01144: File size (20480000 blocks) exceeds maximum of 4194303 blocks

.

this is a non-standard tablespace with 4k blocksize.

Afterwards I've to load a 74.6GB flat file data into LINEITEM table of my database. Please suggest how I can resolve this issue.

Oracle 11g(11.1.0.6.0), winxp 32bit
Thanks a alot.

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 6 2010

Added on Jul 7 2010

#11g, #general-database-discussions

3 comments

12,406 views