oracle alter table logging,Oracle nologging 的运用

Oracle nologging 的使用

Oracle 版本: 10.2

NOLOGGING

is supported in only a subset of the locations that support LOGGING

. Only the following operations support the NOLOGGING

mode:

DML

:

Direct-path INSERT

(serial or parallel) resulting either from an INSERT

or a MERGE

statement. NOLOGGING

is not applicable to any UPDATE

operations resulting from the MERGE

statement.

Direct Loader (SQL*Loader)

DDL

:

CREATE

TABLE

... AS

SELECT

CREATE

TABLE

... LOB_storage_clause

... LOB_parameters

... NOCACHE

| CACHE

READS

ALTER

TABLE

... LOB_storage_clause

... LOB_parameters

... NOCACHE

| CACHE

READS

(to specify logging of newly created LOB columns)

ALTER

TABLE

... modify_LOB_storage_clause

... modify_LOB_parameters

... NOCACHE

| CACHE

READS

(to change logging of existing LOB columns)

ALTER

TABLE

... MOVE

ALTER

TABLE

... (all partition operations that involve data movement)

ALTER

TABLE

... ADD

PARTITION

(hash partition only)

ALTER

TABLE

... MERGE

PARTITIONS

ALTER

TABLE

... SPLIT

PARTITION

ALTER

TABLE

... MOVE

PARTITION

ALTER

TABLE

... MODIFY

PARTITION

... ADD SUBPARTITION

ALTER

TABLE

... MODIFY

PARTITION

... COALESCE

SUBPARTITION

CREATE

INDEX

ALTER

INDEX

... REBUILD

ALTER

INDEX

... REBUILD

[SUB]PARTITION

ALTER

INDEX

... SPLIT

PARTITION

For objects other than LOBs

, if you omit

this clause, then the logging attribute of the object defaults to the

logging attribute of the tablespace in which it resides.

------------------------------------------------------

Consider Using NOLOGGING When Creating Tables/Index

Space is saved in the redo log files.

The time it takes to create the index/tables is decreased.

Performance improves for parallel creation of large indexes/tables.