Home » Server Options » Replication » ORA-00942: table or view does not exist (oracle 10.2.0)
ORA-00942: table or view does not exist [message #336670] Mon, 28 July 2008 10:57 Go to next message
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
Re: ORA-00942: table or view does not exist [message #336684 is a reply to message #336670] Mon, 28 July 2008 12:28 Go to previous messageGo to next message
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
Re: ORA-00942: table or view does not exist [message #336686 is a reply to message #336684] Mon, 28 July 2008 12:45 Go to previous messageGo to next message
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

Re: ORA-00942: table or view does not exist [message #336785 is a reply to message #336686] Tue, 29 July 2008 00:18 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: ORA-00942: table or view does not exist [message #336973 is a reply to message #336913] Tue, 29 July 2008 08:43 Go to previous messageGo to next message
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
Re: ORA-00942: table or view does not exist [message #337268 is a reply to message #336973] Wed, 30 July 2008 06:18 Go to previous messageGo to next message
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
Re: ORA-00942: table or view does not exist [message #337272 is a reply to message #337268] Wed, 30 July 2008 06:43 Go to previous messageGo to next message
umesh049
Messages: 4
Registered: July 2008
Junior Member
Hi,

I am facing problem between

master definition site and master site.

Thanks
Re: ORA-00942: table or view does not exist [message #337273 is a reply to message #337272] Wed, 30 July 2008 06:47 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Yes; go throw the below link.

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

PS: Look Step 4

Babu

[Updated on: Wed, 30 July 2008 06:48]

Report message to a moderator

Previous Topic: Best practise: Should the Target DB in replication be in archive-log mode?
Next Topic: Status of Refresh group to Broken
Goto Forum:
  


Current Time: Thu Mar 28 20:44:15 CDT 2024