DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-12028: materialized view type is not supported by master site

Threaded View

  1. #1
    Join Date
    Jul 2005
    Posts
    87

    ORA-12028: materialized view type is not supported by master site

    Hi ,
    I am trying to create a materialized view to replicate data from database A to database B on a table(exist on database A) whose characterset is AL24UTFFSS(DB A 8174)) which is different from characterset of db B(AL32UTF8 10g).

    Series of steps on :
    I)On db A

    1)Created Materialized view log on master table(UWS_LOT )


    II)On db B

    connect test/test
    1)SQL> create database link aa connect xyz to identified by XXXX using 'aa.xx.com';

    Database link created.

    2)SQL> create materialized view test.mv_UWS_LOT refresh fast as select * from xyz.UWS_LOT@aa;
    create materialized view test.mv_UWS_LOT refresh fast as select * from xyz.UWS_LOT@aa
    *
    ERROR at line 1:
    ORA-12028: materialized view type is not supported by master site
    @AA.XX.COM

    then created MV with rowid,

    create materialized view test.mv_UWS_LOT refresh fast with rowid as select * from xyz.UWS_LOT@aa;

    ERROR at line 1:
    ORA-12703: this character set conversion is not supported
    ORA-06512: at line 1


    Please let me know what needs to be done to fix it.

    Regards
    Last edited by areeb; 01-15-2008 at 11:21 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width