-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|