Working with Oracle

• Topics

  Started by

  Posts

  Last post

• Picking up Oracle development skills

  Hi all, I've been working with SQL Server in a development capacity for about 7 years now. I'm no …

  Sam Peascod

  22 replies

  16 years, 3 months ago

  By: Gift Peddie

• Loading Data into Oracle Server from Access DB using SSIS :- Performance Issue

  I have approx. 1 million rows in my source table and it loads 0.2 million and gives low buffer memo…

  ashloveu27

  3 replies

  16 years, 4 months ago

  By: Vijaya Kadiyala

• Msg 7415 Trying to Execute openrowset to Oracle

  Hello, I am trying to use openrowset to do an ad-hoc query against an Oracle (10.2.1.0) database, u…

  matt.blanchette

  3 replies

  16 years, 4 months ago

  By: Gift Peddie

• SQL data migration to ORACLE

  Hello, I am using the Workbench now to migrate the SQL database data to Oracle database (tables are…

  Vichka

  6 replies

  16 years, 4 months ago

  By: Vichka

• How to Insert / Update to Oracle via Linked Server from SQL2005 - with commit?

  Hello, I have an Oracle table, where I have to insert / update records. It all works using the Orac…

  birgit.schelloeh

  5 replies

  16 years, 4 months ago

  By: PaulB-TheOneAndOnly

• Need some DBA instruction

  About six hours ago I became the admin of a 9.2 box running on an IBM 550 AIX box and I have almost…

  Wayne West

  6 replies

  16 years, 4 months ago

  By: PaulB-TheOneAndOnly

• Oracle to SQL Server migration from an Oracle perspective

  Hello We are investigating the possibility of migrating from Oracle to SQL server. We are currentl…

  Bravid

  7 replies

  16 years, 4 months ago

  By: RBarryYoung

• What is 'i' in Oracle 9i

  Hi, I want to know what is 'i' stand for in Oracle 9i......

  ankitthefire007

  5 replies

  16 years, 4 months ago

  By: Jeff Moden

• change datatype of column

  hi, I am trying to change data type of a column from number to varchar2.(Data base has data). CREA…

  kavitha.shivaramaiah

  4 replies

  16 years, 4 months ago

  By: kavitha.shivaramaiah

• Cannot get the data of the row from OLE DB provider "Sql server" for linked server "(null)

  Hi, I have created linked server to Oracle. What is most interesting I can see all tables. I can m…

  Jagger-784276

  3 replies

  16 years, 5 months ago

  By: aleksandar.kostovski

• SnapShot Oracle - SQL

  Hi, Everyone of us know that snapshots in Oracle and in SQL but with little difference: In Oracle y…

  Dugi

  3 replies

  16 years, 5 months ago

  By: Mohammad Mazharuddin Ehsan

• SSAS And Oracle - Can't connect to the data source

  We're bringing up a new SSAS 2005 instance, and the user needs to connect to an Oracle server for …

  Simon Facer

  1 replies

  16 years, 5 months ago

  By: Simon Facer

• Converting to MSSQL 2005 from Oracle 10g (I'M STRUGGLING!!)

  I've recently started a new job and my role (as a DBA) is to assist with converting an Oracle 10G d…

  dmizelle-679917

  3 replies

  16 years, 5 months ago

  By: Steve-3_5_7_9

• DB Link from Oracle to SQL Server

  Hi, I have created a DB Link 'testsqlserver' from Oracle to Sql Server. I am doing a query from a v…

  SHAILAJA_SOMISETTY

  2 replies

  16 years, 6 months ago

  By: gints.plivna

• Problems with CASE in WHERE

  Hi, I'm trying use this clause in WHERE: ... WHERE CASE :Hist WHEN '2' THEN (PERSON.DATE is n…

  smacena

  6 replies

  16 years, 6 months ago

  By: PaulB-TheOneAndOnly