Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_REDEFINITION.start_redef_table reference partitioning returns ORA-02297

Atanas81Jan 27 2016 — edited Jan 28 2016

Dear Experts,

I need your help.

I am using Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit.

I have a table with column stored as nested table.

I am trying to add reference partitioning to the table (on another column).

However, when I run DBMS_REDEFINITION.start_redef_table, it returns an error ORA-02297 - cannot disable constraint (unique constraint for the nested table) - dependencies exist

What should I do to add partitioning to this table?

Thank you for your time and consideration.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 25 2016
Added on Jan 27 2016
7 comments
1,767 views