ORA-01654 Error Handling

From: beerora <beersa.beersa_at_gmail.com>
Date: 13 Sep 2006 03:47:32 -0700
Message-ID: <1158144452.123251.206720@i3g2000cwc.googlegroups.com>

Hi,

My machine WINXP running oracle8i client. The server is oracle9i.

In my appln, one table has 3652 rows. I delete all by SQL command: DELETE FROM myTable;
After that, I've re-loaded the data by sqlLoader. Only 2868 rows can be inserted and for rest I got following error in log file.

<<ORA-01654: unable to extend index HOME.PK_TB_ACCT by 64 in tablespace

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

Can pls guide me to solve this?

Thanks & Regards,
beer Received on Wed Sep 13 2006 - 05:47:32 CDT