NOLOGGING Wrap-up
The operations that may be performed in a NOLOGGING mode are as follows:
特别注意，在非归档下，Create表和索引都不会产生大量日志。
You would not see the differences
in redo size in a NOARCHIVELOG mode database as the index CREATE and REBUILD operations are not logged in
NOARCHIVELOG mode.
If you test this on a NOARCHIVELOG-mode database, The CREATE TABLE will not be logged, with the exception of the data dictionary modifications, in a NOARCHIVELOG-mode database.
[@more@]• Index creations and ALTERs (rebuilds).
• Bulk INSERTs into a table using a direct-path INSERT such as that available via the
/*+ APPEND */ hint or SQL*Loader direct-path loads. The table data will not generate redo, but all index modifications will (the indexes on this nonlogged table will generate redo!).
• LOB operations (updates to large objects do not have to be logged).
• Table creations via CREATE TABLE AS SELECT.
• Various ALTER TABLE operations such as MOVE and SPLIT.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/14377/viewspace-1059435/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
vmware 添加硬盘
下一篇：
备份集地址变了
请登录后发表评论
登录
全部评论
