| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: select and rollback
The explanation of ORA-1555 alone justifies the entire cost of this book. Anyone asking about ORA-1555 and/or rollbacks needs to be told to immediately purchase a copy.
Jared
"Charlie
Mengler" To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
<charliem_at_mwh. cc:
com> Subject: Re: select and rollback
Sent by:
root_at_fatcity.c
om
11/15/01 07:05
AM
Please respond
to ORACLE-L
The timing of this question is amazing.
Just yesterday I was reading in Tom Kyte's book
"Expert One-on-One" ISBN 1-861004-82-6
about this specific topic.
The short answer is "YES!"
For a more complete answer RTFB.
Hatzistavrou Giannis wrote:
>
> Dear All,
>
> I have a select statement that when runs it complains about limited
rollback
> segment extents. Do selects use rollback?
>
> Regards
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hatzistavrou Giannis
> INET: j.hatzistavrou_at_telesoft.gr
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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).
-- Charlie Mengler Maintenance Warehouse charliem_at_mwh.com 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Extraordinary DBA - Design on the Fly & Just In Time Programming -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: charliem_at_mwh.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Jared.Still_at_radisys.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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 Thu Nov 15 2001 - 15:41:23 CST
 |
 |