OraFAQ Forum: Replication » ORA-03113: end-of-file on communication channel

Home » Server Options » Replication » ORA-03113: end-of-file on communication channel

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-03113: end-of-file on communication channel [message #75254]

Fri, 23 August 2002 03:34

Prachi Khedkar
Messages: 1
Registered: August 2002

Junior Member

Hi,

I am trying to replicate the Data from Oracle 9 to Oracle 8 database. I have successfully created the database link and after that am creating a snapshot (complete refresh). Since the original DB doesn't have all tables with PKs (primary keys) I have to use 'with rowid' option. However, when I execute this query to create snapshot I get the following error -

ORA-03113: end-of-file on communication channel.

If I try to create snapshot for a table with PK and without 'with rowid', replication is successfully done.

Can anybody help me resolve this ?

Thanks in advance,

Prachi

Report message to a moderator