Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sonu_bariar
Starting Member
4 Posts |
 Posted - 2011-07-27 : 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/955If 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
2 Posts |
Posted - 2012-07-06 : 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
2 Posts |
Posted - 2012-07-06 : 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
4 Posts |
Posted - 2012-07-23 : 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 |
|
|
|
|
|
|
|
|
SQL Server to Oracle replication