Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01654 Error Handling
LJ wrote:
> I'm very upset that someone would give the type of reply that Sybrand
> Bakker did. No one in this world knows everything. We are each
> specialists in what we do. Others are more so than others. This is
> why we have these groups and message boards. If we all knew as much as
> Sybrand Bakker did, we'd all be Senior Oracle DBA's.
>
> 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
You shouldn't be upset. Actually if everyone would at least spend some
effort to resolve their own problems, they would *LEARN* something, and
they would become Senior Oracle DBA automatically. Now almost everyone
jumps to the newsgroup crying for help without even looking up the
error message in the documentation.
To me, those persons show they are fundamentally lazy, and requests
*others* to do *their* work *for free*.
Consequently, I will continue to chastize those persons for their
behavior.
Lazy people don't belong in this profession, and lazy persons who are
ripping us from our jobs, as they, due to their incompetency, are
cheap, don't belong here at all.
-- Sybrand Bakker Senior Oracle DBAReceived on Thu Sep 14 2006 - 04:45:21 CDT