I am back with further question about read only replication.
It turns out that 5 of tables I have to replicate have user defined type/objects. I am not able to replicate these tables, getting this error all the time:
It seems that this is not supported or what? Although in 9i New Features it does say user defined types are supported.
Any comments?
TIA
Alex
On 5/12/06, amonte <ax.mount@(protected)> wrote: > > Ah right that is the nice old way I was talking about. > > Time to find out how to define the refresh groups now :-) > > Alex > > > On 5/12/06, Ghassan Salem <salem.ghassan@(protected)> wrote: > > > > Alex, > > just create snapshot logs on the master site, and MVs on the 'slave > > sites'. You can use refresh groups to insure consistency. replication admin, > > proxy admin, ... are used when you have updatable snapshots (or > > master-master replication). > > > > rgds > > > > > > On 5/12/06, amonte < ax.mount@(protected)> wrote: > > > > > > Hi all > > > > > > I am trying to replicate 50 tables from one database to another using > > > Oracle 9.2.0.7 on Sun Solaris. this will be basic replication, read > > > only MVs. > > > > > > I am reading the replication manual (which talks about ADVANCED > > > Replication) and it says I need to set up a master site and a materialized > > > view site, then in master site create a replication administrator, proxy > > > administrator etc (more steps). > > > > > > My previous experience in basic replication goes back to Oracle 8, at > > > that time I only hahd to create snapshots at snapshot site and create > > > snapshot logs at master site and create a refresh group to ensure data > > > integrity. > > > > > > In 9.2 do I really need to perform all the tasks I mentioned or I can > > > use the old Oracle 8 way? > > > > > > TIA > > > > > > Alex > > > > > > > >
Hi again<br><br>I am back with further question about read only replication.<br ><br>It turns out that 5 of tables I have to replicate have user defined type /objects. I am not able to replicate these tables, getting this error all the time: <br><br>ORA-21700 (See ORA-21700.ora-code.com): object does not exist or is marked for delete<br><br>It seems that this is not supported or what? Although in 9i New Features it does say user defined types are supported.<br><br>Any comments?<br><br>TIA <br><br>Alex<br><br><br><div><span class="gmail_quote">On 5/12/06, <b class= "gmail_sendername">amonte</b> <<a href="mailto:ax.mount@(protected)">ax.mount @(protected)</a>> wrote:</span><blockquote class="gmail_quote" style="border -left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div><font color="#0000ff" face="Arial" size="2"><font color="#0000ff" face= "Arial" size="2">Ah right that is the nice old way I was talking about. <br><br >Time to find out how to define the refresh groups now :-)<br><br> Alex</font></font></div><div><span class="e" id="q_10b2875294b5d6d4_1"><font color="#0000ff" face="Arial" size="2"><font color="#0000ff" face="Arial" size= "2"><br><br></font></font><div><span class="gmail_quote"><font color="#0000ff" face="Arial" size="2"> <font color="#0000ff" face="Arial" size="2">On 5/12/06, <b class="gmail _sendername">Ghassan Salem </b> <<a href="mailto:salem.ghassan@(protected)" target="_blank" onclick= "return top.js.OpenExtLink(window,event,this)">salem.ghassan@(protected)</a>> wrote:</font></font></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><font color="#0000ff" face="Arial" size="2"><font color="#0000ff" face= "Arial" size="2">Alex,<br>just create snapshot logs on the master site, and MVs on the 'slave sites'. You can use refresh groups to insure consistency. replication admin, proxy admin, ... are used when you have updatable snapshots (or master-master replication). <br><br>rgds</font></font></div><div><span><font color="#0000ff" face="Arial" size="2"><font color="#0000ff" face="Arial" size="2"><br><br></font></font><div ><span class="gmail_quote"><font color="#0000ff" face="Arial" size="2"> <font color="#0000ff" face="Arial" size="2">On 5/12/06, <b class="gmail _sendername">amonte</b> <<a href="mailto:ax.mount@(protected)" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"> ax.mount@(protected)</a>> wrote:</font></font></span><blockquote class="gmail _quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0 .8ex; padding-left: 1ex;"> <div><font color="#0000ff" face="Arial" size="2"><font color="#0000ff" face= "Arial" size="2">Hi all<br><br>I am trying to replicate 50 tables from one database to another using Oracle <a href="http://9.2.0.7" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"> 9.2.0.7</a> on Sun Solaris. this will be basic replication, read only MVs. <br><br>I am reading the replication manual (which talks about ADVANCED Replication) and it says I need to set up a master site and a materialized view site, then in master site create a replication administrator, proxy administrator etc (more steps). <br><br>My previous experience in basic replication goes back to Oracle 8, at that time I only hahd to create snapshots at snapshot site and create snapshot logs at master site and create a refresh group to ensure data integrity. <br><br>In 9.2 do I really need to perform all the tasks I mentioned or I can use the old Oracle 8 way?<br><br>TIA<br><br>Alex<br>
