Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01654 Error Handling

Re: ORA-01654 Error Handling

From: sybrandb <sybrandb_at_gmail.com>
Date: 13 Sep 2006 05:16:52 -0700
Message-ID: <1158149812.621478.284780@p79g2000cwp.googlegroups.com>

beerora wrote:
> 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

Please stop being lazy, look up error 1654 in the error messages manual and the documentation and work from there.

DO NOT EXPECT THIS FORUM TO DO YOUR WORK AND/OR TO TEACH YOU ORACLE.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Wed Sep 13 2006 - 07:16:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US