RE: ROWNUM's peculiarities...

From: MaryAnn Atkinson <maryann_30_at_yahoo.com>
Date: Wed, 09 Jul 2003 09:26:06 -0700
Message-ID: <F001.005C4164.20030709091933@fatcity.com>

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).

Received on Wed Jul 09 2003 - 11:26:06 CDT