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 LazyDBA home page