如何确定Oracle表是否设置了ROWDEPENDENCIES选项？(How can I determine if an Oracle table has the ROWDEPENDENCIES op

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

我只有基本的Oracle工具，即SQL Plus，我需要找出是否使用ROWDEPENDENCIES选项创建了一个表。 这是一个10g的数据库。

并且，如果没有设置，我可以使用ALTER TABLE来设置它，还是我必须删除并重新创建表？

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.

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;

这将为每个表返回“ENABLED”或“DISABLED”。

创建表后，您无法更改此项 ，因此您必须重新创建表以将其设置为开。

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.