Oracle 参数 ALLOW_ROWID_COLUMN_TYPE 官方解释，作用，如何配置最优化建议

:

ALLOW_ROWID_COLUMN_TYPE参数用于控制是否允许Oracle数据库中在每列定义一个ROWID类型值，以便跟踪表中具体记录。该参数允许在表中使用ROWID列以替代一个普通列，可以帮助提高查询的效率。

它是一个系统参数，默认为FALSE，如果希望使用ROWID类型，可以将其设置为TRUE。

要正确设置ALLOW_ROWID_COLUMN_TYPE参数，你必须先按CTRL+S键保存当前更改，然后按F9键以实际生效。你还可以使用以下SQL语句将参数设置为TRUE：

ALTER SYSTEM SET ALLOW_ROWID_COLUMN_TYPE = TRUE SCOPE=SPFILE;

官方英文解释

ALLOW_ROWID_COLUMN_TYPE determines whether table columns of data type ROWID are allowed to be created.

Note:

This parameter is valid only for Oracle Autonomous Database on dedicated Exadata infrastructure. On other types of Oracle databases, the value of this parameter is ignored and ROWID columns are always allowed to be created.

You cannot specify ROWID columns when creating tables, nor can you add ROWID columns to existing tables. If the value of this parameter is changed from true to false at a time when ROWID columns exist in the database, then those columns are allowed to remain. However, Oracle recommends that you leave this parameter set to its default value of false and avoid introducing ROWID columns into Oracle Autonomous Database on dedicated Exadata infrastructure.

If you choose this setting, be aware that ROWID columns are incompatible with rolling upgrade operations and other internal operations that physically move table rows. At a minimum, database activities involving ROWID columns should be suspended during upgrades. Applications using ROWID columns should introduce correctness validation to mitigate against logical errors in the application if a row relocates.

我想要获取技术服务或软件
服务范围：MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式：远程服务、电话支持、现场服务，沟通指定方式服务
技术标签：数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题

本站部分文章参考或来源于网络，如有侵权请联系站长。
数据库远程运维 Oracle 参数 ALLOW_ROWID_COLUMN_TYPE 官方解释，作用，如何配置最优化建议