Home » Server Options » Replication » Replication tables which using context search (ORA-12008)
Replication tables which using context search (ORA-12008) [message #75012] Tue, 13 February 2001 04:12 Go to next message
Anton Melnik
Messages: 1
Registered: February 2001
Junior Member
Hello!
I have the problem with replication tables which have
conetx index.
The master site have table AAA + context index.
On snapshot site, after first replication, I created the same context index.
But after updating AAA on master site, snapshot site can`t refreshing this table.

ORA-12008 : error in snapshort refresf path
ORA-29875: filed in the execution of the ODCIINDEXINSERT routine
ORA-20000: interMedia Text error
DRG-10602: failed to queue DML change to column for primary key
...
...
...

In which problem?
Master DB 8.1.6 for Win2000
Snapshot DB 8.1.6 for Linux

Sorry for bad english.

Anton

----------------------------------------------------------------------
Re: Replication tables which using context search (ORA-12008) [message #75014 is a reply to message #75012] Thu, 15 February 2001 00:17 Go to previous messageGo to next message
Edward Hayrabedian
Messages: 9
Registered: February 2001
Junior Member
Hi,

Pay attention on the fact that you can not run adhoc DDL statements against replicated objects.
You have to use the Replication Manager or the replciation API to alter this objects.

Best regarsd,
Edward Hayrabedian

----------------------------------------------------------------------
Re: Replication tables which using context search (ORA-12008) [message #75047 is a reply to message #75012] Tue, 08 May 2001 13:48 Go to previous messageGo to next message
Tom Moloney
Messages: 1
Registered: May 2001
Junior Member
We were running 8.1.6 on Sun Unix and had to upgrade to 8.1.7 as replication (especially snapshots) and InterMedia (context) do not play well together all the time.

----------------------------------------------------------------------
Re: Replication tables which using context search (ORA-12008) [message #75064 is a reply to message #75014] Tue, 12 June 2001 21:14 Go to previous message
p.viswanadha reddy
Messages: 1
Registered: June 2001
Junior Member
i want know Master-to-Master Replication

----------------------------------------------------------------------
Previous Topic: In Multimaster replication one-way is not working where as other-way replication is working.
Next Topic: changing the sequence number of replicated data
Goto Forum:
  


Current Time: Thu Mar 28 17:50:52 CDT 2024