operations can use of no-logging mode

The following operations can make use of no-logging mode:
direct load (SQL*Loader)
direct-load INSERT
CREATE TABLE ... AS SELECT
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 LOBs in NOCACHE NOLOGGING mode stored out of line

1 comment:

  1. The most effective tips on how to try this exercising is lie down within
    the bench and deliver the burden higher than your chest, then slowly but surely deliver
    the burden back again for your elbows after which
    you can all over again raise the burden once more.

    Feel free to visit my blog: bowflex selecttech 552 dumbbells used

    ReplyDelete