Sorry to bother you guys...

I tried with SQL Server Management Studio, and it worked as expected...

It seems to be an issue with my IDE or jar file...

Restarting my machine helped...

I am using SQL Server 2008 R2

Product Version is 10.50.1600.1.

Product Level: RTM

Edition: Workgroup

BuildClrVersion: v2.0.50727

I tested and found even the following statements have same effect.

create table dbo.tab1 (col1 char(20) NOT NULL default 'E', col2 varchar(20), constraint pk_tab1 primary key(col1) );

alter table dbo.tab1 drop column...

So the multiplexing of transaction log may decrease performance. I mean are the transactions spread across or they are written to a one log (for one transaction) and then to...

Any suggestions/recommendations on multiplexing for Transaction Logs. Is it of any use (like the multiplexing for Datafiles may help reduce the disk contention and also helps administering the space usage...

Please refer to the following link on MSDN for Mapping Datatypes of Oracle and MS SQL Server for an Oracle Subscriber:

http://technet.microsoft.com/en-us/library/ms151738.aspx

One of my seniors had tried it out earlier (checking for ORA-1630 and no ORA-1652). There is no clue about this error in Alert Log on my Unix machine, where...

Oracle version is 10g release 2. As far as data type is concerned, SQL Server follows a standard of Converting any varchar column of length more 4000 to clob, while...

Hello,

I am using SQL Server 2008 on XP machine and want to Replicate a database to an Oracle Database on a Unix machine. The two machines are connected to each...

Thanks to all for a prompt reply.

For SQL Server varchar() larger than 4000 bytes receiving Oracle column should be a CLOB.

SQL Server Replication to Oracle Subscriber converts VARCHAR2(greater than 4000)...