Re: HELP!! ORA-01562

You might just want to truncate the table. This will accomplish the same thing and a lot faster.

Satar Naghshineh <satarnag_at_worldsite.com> wrote in article <34036B59.4BE7_at_worldsite.com>...
> You must be useing Version 7.1 or have small redo log datafiles. Either
> way, just commit after every 50 records.
>
> Satar Naghshineh
> SatarNag_at_worldsite
> Ronnie Jong wrote:
> >
> > Is there a fast way to delete all records contained in a table? I
 tried
> > the following command in SQL*Plus: (Saved_Search is the table name)
> > delete from Saved_Search;
> > The above command takes about 2-3 minutes to run before I got the
> > following 3 errors, consecutively:
> > ORA-01562: Failed to extend rollback segment (id=5)
> > ORA-00604: Error occured at recursive SQL level 1
> > ORA-01581: Attempt to use rollback segment (5) new extent (70) which is
> > being allocated.
> >
> > I tried using Visual Basic 4.0 with Oracle Objects for OLE (Dynaset) to
> > do the above task, but I got the following error:
> > Run-time error '-2147217396(8004100c)':
> > OIP-04108: Invalid Row Reference
> > I am just deleting one record at a time from Saved_Search table
> > (SavSrchDynaset.DbDelete). It deletes about 120 records successfully
> > before erroring out. The total number of records in the table is 450.
> >
> > Thank you very much to whoever answers this question.
> >
> > Ronnie Jong
> > rjong_at_usa.net
>
Received on Thu Aug 28 1997 - 00:00:00 CDT