Working with Oracle

• Topics

  Started by

  Posts

  Last post

• Selecting Oracle catalog view gives wrong results using Linked Server in SQL Server 2008

  select query from a Oracle catalog view using Oracle Linked Server in SQL Server 2008 giving wrong …

  tobin.t

  2 replies

  14 years, 9 months ago

  By: PaulB-TheOneAndOnly

• Error 0xc0207016:

  I tried to run this query in SQL Server 2005 via SSIS but I keep getting the errors below: select '…

  Lajand

  1 replies

  14 years, 9 months ago

  By: Lajand

• Linked server to Oracle error during decryption

  Hi, I've got an issue which i can't get solved temporarily. We have a 64-bits sql server 2005 clust…

  bryan van ritter

  2 replies

  14 years, 10 months ago

  By: PaulB-TheOneAndOnly

• SQL 2008 on 64bit Problem Calling an Oracle 10G SP

  Hi everyone I've read through a number of posts on this issue but haven't found anything that has h…

  alida.online@gmail.com

  2 replies

  14 years, 10 months ago

  By: Welsh Corgi

• ODAC 10.2.0.2.21 Installation failed on Windows Server 2008 (x64 bit)

  Hello, I am trying to install Oracle Data Access Components (ODAC) for Windows 32-bit Release 10.2.…

  BJ-594656

  1 replies

  14 years, 10 months ago

  By: Gift Peddie

• Linked Server to remote Oracle instance

  Forgive me if I'm being a complete Oracle noob here. I am trying to create a linked server in SQL …

  Brnbngls

  4 replies

  14 years, 10 months ago

  By: Brnbngls

• SQL query timeout on Oracle

  Having trouble with a query timing out on an Oracle database (error ORA-01652), hope someone out he…

  mony12

  4 replies

  14 years, 10 months ago

  By: Welsh Corgi

• How to create a function that takes a table name and where clause as parameters

  Hello Everybody, I need to create a function in Oracle that takes the table name and where clause a…

  rasmi.v

  3 replies

  14 years, 10 months ago

  By: Lowell

• Roolback not functioning in OPENQUERY Linked Server call to ORACLE Stored Procedure

  I am doing an BEGIN TRANSACTION OPEN QUERY Call to an ORACLE Stored Procedure thru a Linked Server …

  mhilligas

  10 replies

  14 years, 11 months ago

  By: spaghettidba

• Oracle to Oracle ETL PL/SQL vs SSIS

  We started exploring SSIS (2008) to do some Oracle to Oracle (10gR2) ETL but some of our developers…

  baal32

  4 replies

  14 years, 11 months ago

  By: PaulB-TheOneAndOnly

• SSIS(SQL 2008) ...taking data from Oracle

  Is there any possibility to design the SSIS in SQL Server 2008 to transfer data from Oracle to SQL …

  Dugi

  6 replies

  14 years, 11 months ago

  By: Dugi

• oracle to oracle etl using SSIS

  Hi Folks, one of the new guys at our workplace has mentioned that you can do an etl between 2 oracl…

  bodhilove

  4 replies

  14 years, 12 months ago

  By: PaulB-TheOneAndOnly

• time out error while connecting

  Hi Friends, I have created a linked server in my 64 bit SQL Server to connect oracle. connectivity …

  Shivrudra

  3 replies

  15 years ago

  By: Shivrudra

• SSMA: Data Migration from Oracle to SQL 2008 slow

  Hi, we are trying to migrate a database from an machine running Oracle 9i (on Windows Advanced Serv…

  Dietmar Krause

  1 replies

  15 years ago

  By: Gift Peddie

• SQL 2008 to Oracle Performance

  Pretty simple scenario... Windows 2003 x64 EE SQL Server 2008 EE Oracle clients 10.2xxx for both 3…

  Nicholas Cain

  11 replies

  15 years ago

  By: Nicholas Cain