RE:Problems Empty'in Tables

If you are trying to delete all the records from the table(s) then use TRUNCATE TABLE <table_name> instead.
The only drawback is that you cannot ROLLBACK

> -----Original Message-----
> From: Mark Powell [SMTP:markp_at_tsm.u-net.com]
> Posted At: 03 March 1998 16:49
> Posted To: server
> Conversation: Problems Empty'in Tables
> Subject: Problems Empty'in Tables
>
> Hi,
>
> Just trying to empty a table and get the following error message :-
>
> SQL> delete unetuser.e_cust;
> delete unetuser.e_cust
> *
> ERROR at line 1:
> ORA-01562: failed to extend rollback segment number 4
> ORA-01650: unable to extend rollback segment R03 by 64 in tablespace
> RBS
>
>
> SQL>
>
> *Bewildered*, any ideas?
>
> Thanks,
>
> Mark Powell
Received on Tue Mar 03 1998 - 00:00:00 CST