Skip to Main Content
Forums

Oracle Database Express Edition (XE)

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Bug: Can not create materialized view log on 11G XE

jariolaNov 20 2011 — edited Nov 21 2011
Hi,

I log in as HR user and try create materialized view log 
CREATE MATERIALIZED VIEW LOG ON HR.EMPLOYEES;
I get error
>
Error starting at line 1 in command:
CREATE MATERIALIZED VIEW LOG ON HR.EMPLOYEES
Error at Command Line:1 Column:0
Error report:
SQL Error: ORA-00439: feature not enabled: Advanced replication
00439. 00000 - "feature not enabled: %s"
*Cause: The specified feature is not enabled.
*Action: Do not attempt to use this feature.
>

You can create materialized view log on 10G XE without any problem.

Regards,
Jari

http://dbswh.webhop.net/dbswh/f?p=BLOG:HOME:0
This post has been answered by orafad on Nov 20 2011
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 19 2011
Added on Nov 20 2011
#11g, #bug, #database, #log, #xe
2 comments
2,637 views