SQL> create editioning view MY_EXP_EDITION_V as select * from EXP_EDITION_TEST;
create editioning view MY_EXP_EDITION_V as select * from EXP_EDITION_TEST
*
ERROR at line 1:
ORA-42314: editioning view cannot be owned by a non-editioned user
create editioning view MY_EXP_EDITION_V as select * from EXP_EDITION_TEST
*
ERROR at line 1:
ORA-42314: editioning view cannot be owned by a non-editioned user
Solution:
Enable the editioning for the user to create editioned objects
SQL> alter user test enable editions;
User altered.
SQL> create editioning view MY_EXP_EDITION_V as select * from EXP_EDITION_TEST;
View created.
Comments
Post a Comment