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] 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] Message-----
From: Derrick Pitts [mailto:[Email Address Removed] 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] subscribe: send a blank email to oracledba-[Email Address Removed] 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] subscribe: send a blank email to oracledba-[Email Address Removed] 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 LazyDBA home page