Does "Alter Table Move Tablespace" Fire DML Triggers? [ID 460489.1]
		修改时间 24-AUG-2010 类型 HOWTO 状态 MODERATED

In this Document
Goal
Solution
References

---

Platforms: 1-914CU;

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.5 to 10.2.0.3 - Release: 9.2 to 10.2
Information in this document applies to any platform.

Goal

When doing ALTER TABLE ... MOVE to re-organize a table and move to another tablespace... Is
this going to fire DML triggers (on update, insert, delete) ?

Solution

No, DML triggers are not going to fire during table re-organization process.
Because table move is a DDL operation.

References

NOTE:147356.1 - How to Move Tables from One Tablespace to Another.

相关的 产品 Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition

返回页首

[@more@]