hm..., I think it will still use the rollback segment for read consistency, it
just doesn't log in the redo log.
Try using PL/SQL block, something like:
DECLARE
v_cnt NUMBER := 0;
CURSOR a_cursor IS
SELECT <UNIQUE/PK> FROM <TABLE>
WHERE <DELETE CONDITION>;
BEGIN
FOR a_row IN a_cursor LOOP
DELETE FROM <TABLE>
WHERE <UNIQUE/PK> = a_row.<UNIQUE/PK>;
v_cnt := v_cnt + 1;
IF v_cnt > 50000 THEN
COMMIT;
v_cnt := 0;
END IF;
END LOOP;
COMMIT;
END;
/
HTH.
Gunawan Yuwono
Oracle DBA
Kansas City
--- "Pfaff, Jody" <jody.[Email Address Removed] wrote:
>
> Depending on your Oracle version...
>
> You may have to use...delete from <table> nologging where <condition>;
>
> I guess they think that sounds less damaging.
>
> Jody
>
>
> -----Original Message-----
> From: Wayne Scotchmer [mailto:[Email Address Removed] Sent: Friday, June 28, 2002 5:14 PM
> To: LazyDBA.com Discussion
> Subject: RE: Rollback Segment and Commit
>
>
> Try
>
> delete from <table> unrecoverable where <condition>
>
> Thanks.
> __________________________________
> Wayne Scotchmer
> Implementation Consultant
> North Plains Systems Corp.
>
> P: 905.565.1900
> F: 905.565.1978
> [Email Address Removed] http://www.northplains.com
> __________________________________
>
> -----Original Message-----
> From: Derrick Pitts [mailto:[Email Address Removed] Sent: Friday, June 28, 2002 11:05 AM
> To: LazyDBA.com Discussion
> Subject: Rollback Segment and Commit
>
>
> Gurus,
>
> I'm trying to delete about 400,000 rows from a table.
> When 1 run my SQL statement I receive an error message
> about the rollback segments not able to extend. I did
> a commit.
>
> Does anyone know of a way to commit after so many
> records have been deleted?
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
Oracle LazyDBA home page