Working with Oracle

• Topics

  Started by

  Posts

  Last post

• 64 bit SQL Server 2005 - Connecting to Oracle using OPENROWSET

  I have a client with our application installed on SQL Server 2005 (64 bit) Enterprise Edition (SP3)…

  Jenny Richardson

  8 replies

  14 years, 10 months ago

  By: Jenny Richardson

• Extract data from Oracle DB to SQL 2005 DB

  I need to write an SQL procedure that can access data in an Oracle DB and insert it into an already…

  bzabel

  2 replies

  14 years, 10 months ago

  By: Steve Jones - SSC Editor

• Apply WHERE criteria to a view based on a linked server

  Hi to all. I am facing the following issue: I have a SQL Server 2005 32-bit running on a 64-bit Wi…

  kapamaroukalt

  2 replies

  14 years, 10 months ago

  By: kapamaroukalt

• Migrate data from sql server to oracle problem

  Hi All, I want to replicate data from Sql Server to Oracle db with using linked server. For this re…

  sukrandere 74618

  5 replies

  14 years, 10 months ago

  By: PaulB-TheOneAndOnly

• OEM SQL Server Plug-in Metrics Monitoring Issues

  New to Oracle (and OEM), not new to SQL Server, I am testing our new installation of the SQL Server…

  CavyPrincess

  6 replies

  14 years, 11 months ago

  By: PaulB-TheOneAndOnly

• Ora OLE DB linked server problems - SQL Server 2005

  SQL server 2005 with Windows Server 2003 R2 During installation of SQL Server 2005, sa login was cr…

  samiam914

  3 replies

  14 years, 11 months ago

  By: PaulB-TheOneAndOnly

• Compare primary key between tables from Oracle and SQL server using SSIS

  Hi I m looking for a way to compare a primary key value in Oracle with values in SQL Server - IN SS…

  conningtower

  1 replies

  15 years, 1 month ago

  By: PaulB-TheOneAndOnly

• oracle recovery partitions

  Hello all, I have a question for oracle, is it possible to recover only partition from backup tape …

  hbujar

  1 replies

  15 years, 1 month ago

  By: PaulB-TheOneAndOnly

• Does anyone know where i can find information on writing php pages that work with oracle?

  I am writing a simple page for a real estate agency and need information on how to write pages to s…

  kksamian301

  1 replies

  15 years, 1 month ago

  By: Gail Shaw

• ORA-00933 - SQL command not properly ended

  We have inherited an application written by a consultant. One of the SSIS packages connects to an…

  S Hodkinson

  10 replies

  15 years, 1 month ago

  By: S Hodkinson

• Yet another linkserver problem ....

  Environments: 1: Windows Server 2003 32-bit; MSSQLServer 2005 (both with all apppropriate SP's appp…

  Opus

  4 replies

  15 years, 1 month ago

  By: Opus

• Is this valid in Oracle?

  Is the following query legal in Oracle? SELECT SUM(MAX(POINTS)) FROM PS_HRS_JO_SCR_CMPP WHERE HRS_J…

  Lynn Pettis

  3 replies

  15 years, 2 months ago

  By: PaulB-TheOneAndOnly

• Arabic display over 10g linked server

  - I created a linked server "Microsoft OLE DB Provider for Oracle" to pull data from Oracle 10g. - …

  Nawar.Tabaa

  1 replies

  15 years, 2 months ago

  By: Nawar.Tabaa

• Cannot extract date range from Oracle into SQL Server

  I'm using an SSIS package with an OLEDB connection. I'm trying to populate a table for the first t…

  born2bongo

  4 replies

  15 years, 2 months ago

  By: PaulB-TheOneAndOnly

• Inserting data from Oracle into SQLServer tables

  I am trying to insert into an SQL Server table from Oracle. The SQL Server table has a column "Id" …

  Globalidentity

  15 replies

  15 years, 2 months ago

  By: Globalidentity