Working with Oracle

• Topics

  Started by

  Posts

  Last post

• Startup and Shutdown + Tsql sqlserver 2005

  Hi , Is there a Way to shutdown and startup a single Database (like Oracle) in sqlserver. I know th…

  gaganks

  11 replies

  15 years, 8 months ago

  By: mithalsnothon

• SSMA for Oracle didn't show all the schemas

  I am trying to migrate an Oracle 10 database to SQL Server 2005, with SSMA. However, not all the s…

  Walter Ren

  1 replies

  15 years, 8 months ago

  By: PaulB-TheOneAndOnly

• MSDAORA Driver Max String Length

  I am running into a WALL. I am sending strings to ORACLE thru a Linked Server using MSDAORA. I have…

  mhilligas

  1 replies

  15 years, 8 months ago

  By: Kees Beimans

• Oracle linked server function return unexpected values

  Hello everybody: I have a linked server from SQL Server 2000 and SQL Server 2005 to Oracle 10g. Bot…

  Hernán Rojas

  5 replies

  15 years, 9 months ago

  By: PaulB-TheOneAndOnly

• migrating tables from Oracle to SQL Server

  when i migrate tables from oracle to sql server using import/export wizard , i choose option delete…

  praveen_delight 24284

  6 replies

  15 years, 9 months ago

  By: PaulB-TheOneAndOnly

• Insert statement with subsititutin variables and To_date

  I am trying to use a substitution variable with a to_date in a insert statement but I keep getting …

  lozar

  1 replies

  15 years, 9 months ago

  By: lozar

• ORA-01403 error when executing sql statement using linked server

  Hi We have a linked server from SQL Server 2005 to Oracle 10.1.2 and is been working fine for almo…

  lijusmail

  2 replies

  15 years, 9 months ago

  By: SQLDCH

• null values

  I am having a brain fart and can't figure this one out. I have 3 columns I am running a query on …

  lozar

  8 replies

  15 years, 10 months ago

  By: Jeff Moden

• Migration

  Hi friends, I'm here to see if you anyone of can provide me with some help on migrating a few sql …

  newbie00001

  5 replies

  15 years, 10 months ago

  By: abatej

• dateadd function

  Hi friends, I'm trying to convert this piece of code to Oracle and kind of stuck with it.. This i…

  newbieuser

  11 replies

  15 years, 10 months ago

  By: abatej

• SQL query

  Hi friends, I run this query in Oracle to find the duplicates of all occurences in a table for the…

  newbieuser

  11 replies

  15 years, 10 months ago

  By: Mohammad Mazharuddin Ehsan

• Connection string?

  Hi friends, Have any of you used connection string to connect from SQl server to Oracle database? …

  newbieuser

  6 replies

  15 years, 10 months ago

  By: shriweb02

• Error connecting to Oracle across SQL Server Linked Server

  I am trying to dynamically read an Oracle table across a SQL Server linked server. My oracle 10g …

  thomas.gervais

  1 replies

  15 years, 10 months ago

  By: Ed B

• Convert FROM SQL BOOLEAN TO ORACLE INT

  Hi , I am making a SSIS job to transfer data from SQL Server to Oracle database which have the same…

  hi.shobhit76

  3 replies

  15 years, 10 months ago

  By: becklery

• SQL Transactional Replication from Oracle

  We are working on a Proof-Of-Concept for an DR configuration, including Oracle front-end databases …

  Simon Facer

  1 replies

  15 years, 10 months ago

  By: serviceforum2009