| Author |
 Topic  |
|
|
sonu_bariar
Starting Member
USA
4 Posts |
 Posted - 07/27/2011 : 12:03:07
|
I am setting up transactional replication to replicate one table from SQL Server 2008 R2 to Oracle 11g. I created the table in Oracle schema. There are some dependencies on this table and we cannot allow SQL Server to Drop and Re-Create the table in oracle, so I set the option "Keep existing object unchanged" in the "article->destination object->Action if name is in use" property in the publication setup.
But this is not working. It try to create the object and give below error.
Command attempted:
CREATE TABLE UCS_USER(
XXXXXXXXXX
(Transaction sequence number: 0x0000006800001B0800C800000000, Command ID: 5)
Error messages:
• ORA-00955: name is already used by an existing object (Source: MSSQL_REPL_ORACLE, Error number: 955)
Get help: http://help/955
• ORA-00955: name is already used by an existing object (Source: MSSQL_REPL_ORACLE, Error number: 955)
Get help: http://help/955
If I set the Option “Drop existing object and create a new one” It works.
Any help please. I want to keep the existing object unchanged.
|
|
|
mohanaram.g
Starting Member
USA
2 Posts |
Posted - 07/06/2012 : 11:33:54
|
Hi sonubariar,
I have the same problem. Did u find out the reason why it is not working with keep the existing object unchanged.
mohanaram.g |
 |
|
|
mohanaram.g
Starting Member
USA
2 Posts |
Posted - 07/06/2012 : 11:33:58
|
Hi sonubariar,
I have the same problem. Did u find out the reason why it is not working with keep the existing object unchanged.
mohanaram.g |
|
|
|
sonu_bariar
Starting Member
USA
4 Posts |
Posted - 07/23/2012 : 15:45:17
|
Hi Mohanaram,
Once you create the publication,run this stored procedure on publication Database to make the changes in the properties of the publication, not to generate the scripts to create the objects.
DECLARE @publication AS sysname;
DECLARE @article AS sysname;
DECLARE @option AS int;
SET @publication = N'Publication_Name';
SET @article = N'Article_Name';
SET @option = 0;
EXEC sp_changearticle
@publication = @publication,
@article = @article,
@property = N'schema_option',
@value = @option
|
|
|
| |
Topic |
|
SQL Server to Oracle replication
