OraFAQ Forum: Replication » ORA-00942: table or view does not exist

Home » Server Options » Replication » ORA-00942: table or view does not exist (oracle 10.2.0)

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

ORA-00942: table or view does not exist [message #336670]

Mon, 28 July 2008 10:57

umesh049
Messages: 4
Registered: July 2008

Junior Member

Hi,

I have two schema on the two servers for replication replication is working fine.

i export one schema to another so all the tables exists at both the sites.

I am adding objects in the replication group using oracle enterprise manager

console.

some of the tables added fine.

but some gives me error like.

ORA-23309: object UMESH.PRODUCT_MASTER of type TABLE exists

before adding this objects in the group i do like

SQL> SELECT oname FROM DBA_REPOBJECT ;

ONAME
------------------------------
AC_ACCOUNT
AC_ACCOUNT$RP
AC_ACCOUNT$RP
AC_ACCOUNT_MASTER
AC_ACCOUNT_MASTER$RP
AC_ACCOUNT_MASTER$RP

6 rows selected.

at both the sites.

when i add product_master in the group then entries becomes like

SQL> SELECT oname FROM DBA_REPOBJECT ;

ONAME
------------------------------
AC_ACCOUNT
AC_ACCOUNT$RP
AC_ACCOUNT$RP
AC_ACCOUNT_MASTER
AC_ACCOUNT_MASTER$RP
AC_ACCOUNT_MASTER$RP
PRODUCT_MASTER

7 rows selected.

but with the error in

and when generate replication support.

SQL> select status,request,message,oname from dba_repcatlog;

STATUS REQUEST
-------------- -----------------------------
MESSAGE
--------------------------------------------------------------------------------
ONAME
------------------------------
ERROR CREATE_MASTER_REPOBJECT
ORA-23309: object UMESH.PRODUCT_MASTER of type TABLE exists
PRODUCT_MASTER

ERROR CREATE_MASTER_REPOBJECT
ORA-23309: object UMESH.PRODUCT_MASTER of type TABLE exists
PRODUCT_MASTER

STATUS REQUEST
-------------- -----------------------------
MESSAGE
--------------------------------------------------------------------------------
ONAME
------------------------------

ERROR GENERATE_INTERNAL_PKG_SUPPORT
ORA-23308: object UMESH.PRODUCT_MASTER does not exist or is invalid
PRODUCT_MASTER

ERROR GENERATE_INTERNAL_PKG_SUPPORT
ORA-23308: object UMESH.PRODUCT_MASTER does not exist or is invalid

STATUS REQUEST
-------------- -----------------------------
MESSAGE
--------------------------------------------------------------------------------
ONAME
------------------------------
PRODUCT_MASTER

ERROR GENERATE_INTERNAL_PKG_SUPPORT
ORA-23308: object UMESH.PRODUCT_MASTER does not exist or is invalid
PRODUCT_MASTER

OR

SOME TIMES I GOT ERROR LIKE

ORA-00942: table or view does not exist

when use CREATE_MASTER_REPOBJECT command to create object at

master definition site while the the table exists at the master site.

but in the same situation other objects are working fine.

i am fed up with this error.

any help will be appreciated.

Thanks
Umesh

Report message to a moderator

Re: ORA-00942: table or view does not exist [message #336684 is a reply to message #336670]

Mon, 28 July 2008 12:28

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello Umesh.

Please before posting your query; Please read the below link

http://www.orafaq.com/forum/t/88153/0/

>>i export one schema to another so all the tables exists at both the sites.

1. Please post your database version.
2. Can you explain me; abt your exported schema. I mean your exported materialized object?

Babu

Report message to a moderator

Re: ORA-00942: table or view does not exist [message #336686 is a reply to message #336684]

Mon, 28 July 2008 12:45

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello again,

SQL> select status,request,message,oname from dba_repcatlog;

STATUS REQUEST
-------------- -----------------------------
MESSAGE
--------------------------------------------------------------------------------
ONAME
------------------------------
ERROR CREATE_MASTER_REPOBJECT
ORA-23309: object UMESH.PRODUCT_MASTER of type TABLE exists
PRODUCT_MASTER

Please confirm me; object status VALID/INVALID; use

SELECT ONAME,STATUS,TYPE FROM DBA_REPOBJECT WHERE SNAME='UMESH'

Babu

Report message to a moderator

Re: ORA-00942: table or view does not exist [message #336785 is a reply to message #336686]

Tue, 29 July 2008 00:18

umesh049
Messages: 4
Registered: July 2008

Junior Member

SQL> SELECT ONAME,STATUS,TYPE FROM DBA_REPOBJECT WHERE SNAME='UMESH';

ONAME STATUS TYPE
------------------------------ ---------- ----------------
AC_ACCOUNT VALID TABLE
AC_ACCOUNT$RP VALID PACKAGE
AC_ACCOUNT$RP VALID PACKAGE BODY
PRODUCT_MASTER VALID TABLE
PRODUCT_MASTER$RL VALID PACKAGE
PRODUCT_MASTER$RL VALID PACKAGE BODY
PRODUCT_MASTER$RP VALID PACKAGE
PRODUCT_MASTER$RP VALID PACKAGE BODY

this is on master definition site version

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

this is on another master site.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production

One more thing i made a new table

by

create table product_master_bkup as select * from product_master ;

and then replicate product_master_bkup table which worked

fine without any error.

[Updated on: Tue, 29 July 2008 02:40]

Report message to a moderator

Re: ORA-00942: table or view does not exist [message #336913 is a reply to message #336785]

Tue, 29 July 2008 05:56

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello again,

Please before posting your query; Please read the below link

http://www.orafaq.com/forum/t/88153/0/

>>create table product_master_bkup as select * from product_master ;

>>and then replicate product_master_bkup table which worked

Can you confirm me. The above statement is correct or not?

1. I thnk you need create snapshot or mv using.

create materialized view product_master_bkup refresh force on select * from product_master ;

Not

create table product_master_bkup as select * from product_master ;

Confirm me.

Babu

Report message to a moderator

Re: ORA-00942: table or view does not exist [message #336973 is a reply to message #336913]

Tue, 29 July 2008 08:43

umesh049
Messages: 4
Registered: July 2008

Junior Member

No its not as you understand

I am using multimaster replication this code i use to create

one table from another.

Actually my problem is my some tables are get replicated but some

give me error like that.

So i made a new table from probuct_master using this query new

tables have every thing same data, structure of table except

constraints and my problem solved.

but i can't understand does constraints creates some problem

in multimaster replication.

Thanks for reply

Report message to a moderator

Re: ORA-00942: table or view does not exist [message #337268 is a reply to message #336973]

Wed, 30 July 2008 06:18

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>I am using multimaster replication this code i use to create

http://download.oracle.com/docs/cd/B19306_01/server.102/b14227/rarmastergroup.htm

>>but i can't understand does constraints creates some problem

in multimaster replication.

Where your facing problem? between Master site <=> Master Site or Materialized View Site?

Babu

Report message to a moderator