Re: Rollback segments

A table which is NOLOGGING is only no-logging for direct load operations - i.e.

    insert /*+ append */ into table select .....

Also, even if associated indices are also NOLOGGING I think that you will find that the index updates are logged even when the /*+ append */ hint is used. (In this case I suspect that NOLOGGIN takes place only when the index is rebuilt - but that's still on my to-do list).

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Greg Akins wrote in message <000b8d9b.24c425ef_at_usw-ex0101-008.remarq.com>...
>I am in the midst of some troubles with Rollback segments.
>
>My rollback tablespace is only half full, but when I run a series of
>inserts into a table with 'nologging', I get an error message that a
>rollback segment can't be extended. Now rollback segment seems to be
>fully extended. However, since I have nologging set and have bounced
>the database and server, I thought the segment should have been
>emptied? But mostly, I just don't think I understand the relation
>between a transaction and Oracles activity against the segments.
>
>I realize this may be a big topic for an online discussion. But maybe
>there are some web resources from which I could get a better
>understanding?
>
>-greg
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
>The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Thu Oct 07 1999 - 09:36:18 CDT