Menu
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?
490
This rowdependencies clause changes the default behavior of Oracle to put an SCN on every row within the tables, and not just one SCN for every physical data block.
The most common type of table in an Oracle database is a relational table, which is structured with simple columns similar to the employees table. Two other table types are supported: object tables and XMLType tables. Any of the three table types can be defined as permanent or temporary.
About Tables Data is stored in rows and columns. You define a table with a table name, such as employees , and a set of columns. You give each column a column name, such as employee_id , last_name , and job_id ; a datatype, such as VARCHAR2 , DATE , or NUMBER ; and a width.
SELECT owner, table_name, dependencies FROM dba_tables;
This will return "ENABLED" or "DISABLED" for each table. If you don't have access to dba_tables, query all_tables instead.
You cannot change this after the table has been created, so you'll have to re-create the table to set it on.
124
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
