Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

If I have a table t

create table t (x var number);

How can I modify the table so that it appears to have been created with rowdependencies?

create table t (x var number) rowdependencies;
share|improve this question
up vote 3 down vote accepted

Unfortunately, you can't (unless something has changed in 12c that I'm not aware of). You'll have to recreate the table with rowdependencies and move all the data from the old table to the new one.

Of course, you could use the dbms_redefinition package to do this redefinition online. But under the covers, you'd still be creating a new table with rowdependencies enabled, copying the data over, dropping the old table and renaming the new one. It would just involve potentially less downtime (at a cost to how long it takes and how much DBA time is required).

share|improve this answer
This has not changed in 12.1 – Phil Feb 6 '14 at 8:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.