ENABLE Clause

最新推荐文章于 2025-12-19 16:00:26 发布

转载最新推荐文章于 2025-12-19 16:00:26 发布 · 75 阅读

文章标签：

#数据库

本文详细介绍了在Oracle数据库中如何使用约束来确保数据的唯一性和完整性。特别关注了在启用约束时自动创建唯一索引的功能，并提供了避免重复索引的方法。此外，还讨论了在不同状态下更改约束的有效策略。

Specify ENABLE if you want the constraint to be applied to the data
in the table.

If you enable a unique or primary key constraint, and if no index exists on the key,
then Oracle Database creates a unique index. Unless you specify KEEP INDEX when
subsequently disabling the constraint, this index is dropped and the database rebuilds
the index every time the constraint is reenabled.

You can also avoid rebuilding the index and eliminate redundant indexes by creating
new primary key and unique constraints initially disabled. Then create (or use
existing) nonunique indexes to enforce the constraint. Oracle does not drop a
nonunique index when the constraint is disabled, so subsequent ENABLE operations
are facilitated.

If you specify neither VALIDATE nor NOVALIDATE, the default is VALIDATE.

If you change the state of any single constraint from ENABLE NOVALIDATE to ENABLE
VALIDATE, the operation can be performed in parallel, and does not block reads,
writes, or other DDL operations.

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-1001505/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-1001505/