Working with Oracle

• Topics

  Started by

  Posts

  Last post

• How to register Oracle Server

  hi guys, How to register Oracle DB server in my MSSQL Enterprise manager. I need to work on tables,…

  Saqib-215297

  1 replies

  16 years, 2 months ago

  By: Vijaya Kadiyala

• ORA-01722: invalid number Error occurred When using DTS

  Hi All; I'd like to copy a part of records in Oracle DB to SQL Server 2000 with DTS. DTS's Steps ar…

  Hirotaka_Hibiya

  3 replies

  16 years, 3 months ago

  By: Jo Pattyn

• www.sqlservercentral.com

  sir i have a problem while creating a procedure to insert values with a table containing foregin ke…

  nevergiveupjohnbenny

  5 replies

  16 years, 3 months ago

  By: karthik M

• Linked Server to Oracle through Microsoft OLEDB provider

  Hi All, I have created a linked server to Oracle database. I have used the below command to create …

  praveen voleti

  4 replies

  16 years, 3 months ago

  By: victor.olufowobi

• Sql Server 2000 Openquery insert takes too long

  To whom can help, I am using Sql Server 2000 and have a linked server to Oracle. I am doing an inse…

  Stewart Fay

  4 replies

  16 years, 4 months ago

  By: Max-146500

• How to synchronise data between SQL Server and Oracle

  Hi all, Rajeev here from Bangalore. This is the present scenario with us. In some multiple sites…

  rajeev_vandakar-782919

  2 replies

  16 years, 5 months ago

  By: aleksandar.kostovski

• Getting data out of Oracle 8i?!!

  Hello, I am working for a company that is going to a new application. The previous application was…

  WebTechie

  1 replies

  16 years, 9 months ago

  By: PaulB-TheOneAndOnly

• Oracle issues

  Hi. Im trying to connect to SQl Server 2000 from Sql Developer, and im getting this error on Sql de…

  aldo.miguel

  1 replies

  16 years, 9 months ago

  By: PaulB-TheOneAndOnly

• Using BCP output with SQLLDR

  Hi everyone, I have a question about using SQLLDR to load some data that I obtained by running BCP …

  Christopher Wright

  2 replies

  16 years, 10 months ago

  By: Christopher Wright

• SQL server 2000 crashes after upgrading oracle9i to oracle 10g

  I have a Win 2k server with SQL server 2000 SP3 running 50+ databases. and 20+ linked servers, many…

  ybol

  7 replies

  16 years, 11 months ago

  By: Erich Brinker

• exporting data from Sql server 2000 t oracle using DTS in sql

  i am trying to export data from sql server 2000 to oracle8i using DTS. it doing the process properl…

  suchita s

  3 replies

  16 years, 12 months ago

  By: gints.plivna

• Connecting to ORACLE through OPENROWSET, without installing ORACLE Client

  Hi, I am trying to connect to an ORACLE instance from SQL Server, without installing ORACLE Client …

  Kaushik Majumder

  4 replies

  17 years, 1 month ago

  By: Kaushik Majumder

• Passing parameter to Oracle via ODBC in DTS data pump lookup

  Hi, I am trying to improve performance on a DTS package. One of the step connects to an Oracle DB v…

  Ashish Mittal

  1 replies

  17 years, 1 month ago

  By: Ashish Mittal

• Getting Error 7399 - OLE DB provider 'ORAOLEDB.ORACLE' reported an error. The provider did not give any information about the error.

  I'm getting the following error while using OPENROWSET: OLE DB provider 'ORAOLEDB.ORACLE' reported…

  Marios Philippopoulos

  4 replies

  17 years, 2 months ago

  By: Marios Philippopoulos

• Oracle9i to SQL Server 2000 Through DTS

  [font="Verdana"]Hi All, I have Oracle9i and SQL Server 2000 installed on my machine. Before two yea…

  Mahesh Bote

  1 replies

  17 years, 2 months ago

  By: Jo Pattyn