Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

1 Answer

up vote 1 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 –  FreshPhilOfSO Feb 6 at 8:03
add comment

Your Answer

 
discard

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.