The following operations are resumable:
* Queries
SELECT statements that run out of temporary space (for sort areas) are candidates for resumable execution. When using OCI, the calls LNOCIStmtExecute() and LNOCIStmtFetch() are candidates.
* DML
INSERT, UPDATE, and DELETE statements are candidates. The interface used to execute them does not matter; it can be OCI, JSQL, PL/SQL, or another interface. Also, INSERT INTO ... SELECT from external tables can be resumable.
* Import/Export
As for SQL*Loader, a command line parameter controls whether statements are resumable after recoverable errors.
* DDL
The following statements are candidates for resumable execution:
o CREATE TABLE ... AS SELECT
o CREATE INDEX
o ALTER INDEX ... REBUILD
o ALTER TABLE ... MOVE PARTITION
o ALTER TABLE ... SPLIT PARTITION
o ALTER INDEX ... REBUILD PARTITION
o ALTER INDEX ... SPLIT PARTITION
o CREATE MATERIALIZED VIEW
o CREATE MATERIALIZED VIEW LOG
resumable是什么意思,我不太能理解。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/79499/viewspace-417641/
,如需转载,请注明出处,否则将追究法律责任。