Error while creating MV replication group object [message #291198] |
Thu, 03 January 2008 06:18 |
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.
-
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 #294848 is a reply to message #291198] |
Sun, 20 January 2008 02:19 |
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
|
|
|