如何确定Oracle表是否设置了ROWDEPENDENCIES选项? [英] How can I determine if an Oracle table has the ROWDEPENDENCIES option set?

问题描述

我只有可用的基本Oracle工具，即SQL Plus，并且我需要确定是否使用ROWDEPENDENCIES选项创建了表.这是一个10克的数据库.

I only have the basic Oracle tools available, i.e. SQL Plus, and I need to find out if a table was created with the ROWDEPENDENCIES option. It's a 10g database.

并且，如果未设置，是否可以使用ALTER TABLE进行设置，还是必须删除并重新创建表?

And, if it isn't set, can I use ALTER TABLE to set it, or do I have to drop and re-create the table?

推荐答案

SELECT owner, table_name, dependencies FROM dba_tables;

这将为每个表返回启用"或禁用".

This will return "ENABLED" or "DISABLED" for each table.

在表包含已创建，因此您必须重新创建表才能将其设置为打开状态.

You cannot change this after the table has been created, so you'll have to re-create the table to set it on.

这篇关于如何确定Oracle表是否设置了ROWDEPENDENCIES选项?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！