ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Managing Resumable Space Allocation 是什么意思

Managing Resumable Space Allocation 是什么意思

原创 Linux操作系统 作者:foxmile 时间:2008-01-11 20:31:25 0 删除 编辑
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/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: 关于Hash Partition
请登录后发表评论 登录
全部评论

注册时间:2007-12-10

  • 博文量
    106
  • 访问量
    217326