Home » Server Options » Replication » Error while creating MV replication group object
Error while creating MV replication group object [message #291198] Thu, 03 January 2008 06:18 Go to next message
arthik_babu
Messages: 8
Registered: December 2007
Junior Member
Hi,

I am getting error while creating replication group object. I tried to create using OEM and SQLPlus

I have attached snapshot of OEM error.

SQL> CONNECT MVIEWADMIN/MVIEWADMIN@SWEET
Connected.
SQL>
SQL> BEGIN
2 DBMS_REPCAT.CREATE_MVIEW_REPOBJECT (
3 gname => 'SCOTT',
4 sname => 'KARTHIK',
5 oname => 'emp_mv',
6 type => 'SNAPSHOT',
7 min_communication => TRUE);
8 END;
9 /
BEGIN
*
ERROR at line 1:
ORA-23306: schema KARTHIK does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 2840
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 773
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 5570
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 82
ORA-06512: at "SYS.DBMS_REPCAT", line 1332
ORA-06512: at line 2

Please not already I have created KARTHIK schema.

/forum/fa/3688/0/
  • Attachment: EM-Jpg.JPG
    (Size: 46.89KB, Downloaded 3490 times)

[Updated on: Thu, 03 January 2008 06:21]

Report message to a moderator

Re: Error while creating MV replication group object [message #291211 is a reply to message #291198] Thu, 03 January 2008 06:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
The 2 errors are not coming from the same statement.
Please post the actual situation.

Regards
Michel
Re: Error while creating MV replication group object [message #294848 is a reply to message #291198] Sun, 20 January 2008 02:19 Go to previous message
mujeeb_andeth
Messages: 2
Registered: January 2008
Junior Member
While creating MV group object means you are creating a new object in the schema. The error here is clear that the name of the object that you try to create is already present in the schema. So either you have to drop the other object or rename the object. So that you can create the MV group object
Thanks
Mujeeb
Previous Topic: No indexes on Materialized view
Next Topic: Alter Materialized View from Complete to Fast
Goto Forum:
  


Current Time: Thu Nov 14 04:18:22 CST 2024