nvarchar(255) shouldn't pose a problem. You might want to compensate for slight multibyte storage differences as the size is expressed in bytes.

SQLServer 1-2 bytes(?) vs oracle 1-4 bytes (depending on...

Do you have a recent version of sql developer? [/url]. Have to research it myself

You cannot update emp again from an after trigger (could cause looping). Try a before insert trigger.

Ps why are you updating the whole table (status=1) for each row?

db servername would be the tns-alias, which is described further in tnsnames.ora.

Like mydb. In tnsnames.ora Mydb= (connection info.... tcp....port....) (see the web for the actual connectionstrings)

Other oracle tools:

tracing, perhaps on module sqlserver.exe, or enable from your openquerysession

General oracle performance tuning

Big data is quite diverse nowadays, somewhat like the cloud.

More like specific problems that might benefit from a non-standard RDBMS approach. Like social media/search robots having scaleout methods where one...

Haven't time to setup a mssql to oracle replication, however some possible helpfull links.

SQL Server Replication

Locks in oracle

Perhaps Statspack if installed on the oracle db (small interval)

Dreaded question: anything changed...

Help needed with cross-vendor replication mssql->oracle

Have you also checked the oracle-side? (tracing,locks etc)

Happy New Year

Can't tell much without actually seeing it. I had success using orafaq[/url], just be sure you read the forum guide. Do you have a testcase (create table, insert data, select...

Agreed, I grasped that per VM there are 4 core licenses necessary. So you only need 4 no matter the underlying hardware cluster (if you only use 4 virtual cpu's...

There is a command to lock an entire table LOCK TABLE employees IN EXCLUSIVE MODE NOWAIT; , but haven't tried this from MSSQL. Perhaps through openquery.

Not sure why you...

Congrats with the rescue Jason

Getting ready for windows 7 & windows server 2012.

Relearning MSSQL and improving the current monitoring for facts & figures.