Working with Oracle

• Topics

  Started by

  Posts

  Last post

• Linked Server from SQL 2008 to Oracle needs port #

  I'm trying to figure out how to create a linked server on SQL 2008r2 to an Oracle db. I have a ser…

  mvallone

  1 replies

  8 years, 8 months ago

  By: Jo Pattyn

• Dates stored as 00-00-00 in database

  Hello all, For a client we have to transfer an ERP database from an Oracle environment into SQL Ser…

  Resender

  2 replies

  8 years, 9 months ago

  By: Jana.Sattainathan

• JOB with SSIS step and proxy account

  Hi everyone, I have problem JOb with SSIS step which failed when proxy user isn't in windows Admini…

  Tom_apt

  2 replies

  8 years, 9 months ago

  By: Tom_apt

• Best practice for temporary working tables.

  OK...so I get that in Oracle you have Global Temp Tables whose structure is permanent, but whose da…

  David McKinney

  10 replies

  8 years, 10 months ago

  By: Jeff Moden

• warm standby rollback

  Hi I Have implement log shipping from Nigeria to Sa using FTP to ship the log files. Has been work…

  anel3

  5 replies

  8 years, 11 months ago

  By: donaldyates123

• LINKED SERVER to NETEZZA QUESTION

  Hello, I have what I hope is a simple question. I have setup a linked server using a System ODBC D…

  David F

  1 replies

  9 years ago

  By: anwar.mir

• Migrating oracle queries to SQL server.

  I am working on migrating DB from Oracle to MS SQL. With SSMA all the procedures and routines are n…

  narengc

  8 replies

  9 years, 2 months ago

  By: fakirasemers

• Export MONEY datatype to Oracle

  I'm exporting a table from SQL Server 2008R2 to Oracle 11g. One of the datatypes in the SQL Server…

  SQLDCH

  7 replies

  9 years, 2 months ago

  By: Luis Cazares

• Finding numeric and alpha vs just alpha data query

  Hi All, Will try and explain this better. We have a SAL field in the database that has numeric and …

  Kazmerelda

  2 replies

  9 years, 2 months ago

  By: Jeff Moden

• SQL gets datatypes wrong using OPENQUERY to oracle

  SQL Server version 2008 R2 Enterprise 64bit ORACLE version 11g Enterprise Edition Release 11.2.0.3.…

  g.britton

  3 replies

  9 years, 3 months ago

  By: nancyagnes30

• Oracle Client 64 Bit fails Architecture prerequisite, it detects that it is a 32 bit machine when in fact it is a 64 bit machine.

  Architecture - This is a prerequisite condition to test whether the system has a certified architec…

  Welsh Corgi

  2 replies

  9 years, 3 months ago

  By: victorjohnson77

• sql server stored procedure using link to oracle fails with date parameters

  I have a stored procedure that uses a SQL Server database and a linked server to an Oracle database…

  Denise McMillan

  2 replies

  9 years, 4 months ago

  By: Denise McMillan

• "Missing parenthesis" error while casting data to VARBINARY in Oracle

  I have a specific need in which I need to convert BLOB data to VARBINARY. When I execute below stat…

  SAMDEV

  1 replies

  9 years, 4 months ago

  By: sgmunson

• Query with linked server works until where clause added

  I have a query: select a.* b.description from sqlservertable a left outer join orac…

  Fred Schmid

  10 replies

  9 years, 4 months ago

  By: cyp901

• 2008R2 to Oracle 8i linked server - ORA-03134: Connections to this server version are no longer supported

  Hey guys, I am unable to connect to the older Oracle 8/8i servers through linked servers using 2008…

  chrisph

  11 replies

  9 years, 6 months ago

  By: Joie Andrew