Re: HELP!! ORA-01562

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 Tue Aug 26 1997 - 00:00:00 CDT