exp,imp 小参数详解（之二）

最新推荐文章于 2023-07-20 10:58:18 发布

傻儿哥

最新推荐文章于 2023-07-20 10:58:18 发布

阅读量820

点赞数

CC 4.0 BY-SA版权

分类专栏： ORACLE 文章标签： nested attributes import table each insert

本文链接：https://blog.youkuaiyun.com/csucxcc/article/details/4847834

ORACLE 专栏收录该内容

106 篇文章

订阅专栏

本文详细解析了Oracle数据库IMP工具中的COMMIT参数的作用与影响。包括不同设置下（如Y/N）的数据导入行为变化，特别是在嵌套表、分区表及包含特定类型列（如LOBs）的表中如何进行事务提交。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

COMMIT
Default: n
Specifies whether Import should commit after each array insert. By default, Import commits only after loading each table, and Import performs a rollback when an error occurs, before continuing with the next object.

If a table has nested table columns or attributes, the contents of the nested tables are imported as separate tables. Therefore, the contents of the nested tables are always committed in a transaction distinct from the transaction used to commit the outer table.

If COMMIT=n and a table is partitioned, each partition and subpartition in the Export file is imported in a separate transaction.

For tables containing LOBs, LONG, BFILE, REF, ROWID, or UROWID columns, array inserts are not done. If COMMIT=y, Import commits these tables after each row.

||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1.如果指定commit=Y，imp的时候每个组(array) insert之后，都会commit.(Specifies whether Import should commit after each array insert.)如果是NO，每个表装后才进行一次commit，如果有错，将回滚这个操作。
2.commit=n的情况下，嵌套表和分区表都是在单独的事务中间提交的。（If a table has nested table columns or attributes, the contents of the nested tables are imported as separate tables. Therefore, the contents of the nested tables are always committed in a transaction distinct from the transaction used to commit the outer table.）
3.对于包含LOBS.LONG.BFILE.REF.ROWID.UROWID列的表，如果选择commit=y,imp的时候会在每行插入之后做commit的操作。