Thanks for the explanations you've all provided. > I still believe that it's easier and faster to expand the RBS > tablespace ...
Not an option. It never was. The requirements were not set by me but the agency(dont ask which one).We cant just go there and tell them, "hey you, increase RBS, NOW!" Function Based Index was not an option either, for the same reason. And dbms_transaction.use_rollback_segment, pretty fancy, I have to admit, but made many assumptions. We have a table, and thats that. We couldnt create no other objects, we just had to work with that. If I had my way I'd update them all in one shot, and commit afterwards and be done with it. But in the process, and thanks to you, I wouldnt have learned about ROWNUM's peculiarities... Many thanks, maa __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
