As long as you are doing INSERT INTO ... using CTAS it can make use of
NOLOGGING according to Oracle. I do not know
why the single table does not use it. Perhaps posting relevant portion of
insert stmt may provide some help
The following
operations can
make use of
NOLOGGING mode:
- direct load
SQL*Loader
- direct-load
INSERT
- CREATE TABLE
... AS SELECT
(CTAS)
- CREATE INDEX
- ALTER TABLE
... MOVE
PARTITION
- ALTER TABLE
... SPLIT
PARTITION
- ALTER INDEX
... SPLIT
PARTITION
- ALTER INDEX
... REBUILD
- ALTER INDEX
... REBUILD
PARTITION
- INSERT,
UPDATE, and DELETE
on non-internal
LOBs in NOCACHE
NOLOGGING
Gurelei
<gurelei@yahoo To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
.com> cc:
Sent by: Subject: Re: insert nologging
parallel/noparallel and archiving
[EMAIL PROTECTED]
om
08/14/2002
10:03 AM
Please respond
to ORACLE-L
Jack,
I have another twist on this situation. Again I'm
loading the tables in nologging mode with all the
indices dropped. Both transactions are insert into
table nologging (select *). The only difference is
that one select is a select from a single table while
the other - is a select from two joined tables.
The first insert (from a single) table produce
archives, while the other (from two tables) - doesn't.
Is there en explanation for that?
thanks
Gene
--- Jack Silvey <[EMAIL PROTECTED]> wrote:
> sorry, meant insert as select, not insert as append
> --- Jack Silvey <[EMAIL PROTECTED]> wrote:
> > Gene,
> >
> > This sounds right.
> >
> > Standard insert as append does freelist block
> > checking
> > and generates redo. Parallel DML generates
> minimial
> > redo, just for the new temp segments being
> created,
> > not for the datablock updates. This is one reason
> it
> > is so fast.
> >
> > Index changes are always logged, even in PDML and
> > append modes.
> >
__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gurelei
INET: [EMAIL PROTECTED]
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [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).
