Home » RDBMS Server » Networking and Gateways » Materialized view data replication
Materialized view data replication [message #560003] Mon, 09 July 2012 02:31 Go to next message
moulshree
Messages: 13
Registered: July 2012
Junior Member
I have two servers:

10g server 10.1.4.30
11g server 10.1.4.32

I have a table testing_mview on 10g which do not have any primary key.
I have created MV log for it:

CREATE MATERIALIZED VIEW LOG ON testing_mview WITH ROWID;
Materialized view log created.


My requirement is
1) if there is an UPDATE/DELETE/INSERT on testing_mview, it should be writen to MATERIALIZED VIEW LOG (this has been achieved)
2) Materialized view testing_mview1 of 11g on server 10.1.4.32 should pull these changes on a scheduled basis ( I have created the database link ORCL10R2 here from 11g to 10 g)

On 11g:
SQL> create database link ORCL10R2 connect to omig identified by pswd using
'(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.4.30)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ICS3)
)
)';

Database link created

SQL> create materialized view testing_mview1 REFRESH FAST with rowid as select * from testing_mview@ORCL10R2;
create materialized view testing_mview1 REFRESH FAST with rowid as select * from testing_mview@ORCL10R2
*
ERROR at line 1:
ORA-04052: error occurred when looking up remote object SYS.DBMS_SNAPSHOT@ORCL10R2
ORA-00604: error occurred at recursive SQL level 2
ORA-06544: PL/SQL: internal error, arguments: [55916], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [55916]
ORA-02063: preceding 2 lines from ORCL10R2


Please help
Re: Materialized view data replication [message #560008 is a reply to message #560003] Mon, 09 July 2012 02:58 Go to previous messageGo to next message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-06544: PL/SQL: internal error, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]
 *Cause: A pl/sql internal error occurred.
 *Action:Report as a bug; the first argument is the internal error nuber.

Regards
Michel
Re: Materialized view data replication [message #560174 is a reply to message #560008] Wed, 11 July 2012 01:46 Go to previous messageGo to next message
moulshree
Messages: 13
Registered: July 2012
Junior Member
Hi Michael, I used
create materialized view testing_mview_1 REFRESH Force with rowid as select * from testing_mview@ORCL10R2 and it was successfull.
Re: Materialized view data replication [message #560176 is a reply to message #560174] Wed, 11 July 2012 01:49 Go to previous message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you investigate on the error?
Did you find anything on it?

Regards
Michel
Previous Topic: database link from 11g to 10g
Next Topic: ORACLE Disconnect every 5 mins
Goto Forum:
  


Current Time: Sun Dec 21 16:00:49 CST 2014

Total time taken to generate the page: 0.07924 seconds