ORA-01654 Error Handling

Giganews Newsgroups
Subject: ORA-01654 Error Handling
Posted by:  beerora (beersa.beer…@gmail.com)
Date: 13 Sep 2006

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

Replies