Working with Oracle

• Topics

  Started by

  Posts

  Last post

• Connectivity to Oracle 12.2 instance via OLE DB ?

  I installed Oracle 12 on Windows 10 in  all possible ways/configurations, including the defaults. I…

  VoldemarG

  3 replies

  5 years, 2 months ago

  By: frederico_fonseca

• I need to move database with 500 tables from SQL Server to Oracle 19

  I have a SQL Server database,  that I need to migrate to Oracle 19. How can I generate all PL/SQL D…

  VoldemarG

  2 replies

  5 years, 4 months ago

  By: VoldemarG

• I need to move database with 500 tables from SQL Server to Oracle 19

  I have a SQL 2014 database, and two more from 2016, that I need to migrate to Oracle 19. How can I …

  VoldemarG

  1 replies

  5 years, 4 months ago

  By: Jeff Moden

• PL/SQL for Concurrent Users

  Hello, I am a SQL Server person but I have been working with PostgreSQL in recent years in addition…

  sahoong

  2 replies

  5 years, 5 months ago

  By: Nice Marmot

• Linked server data type issue

  Hi friends, We have a problem with ODBC driver interpreting data type differently on SQL Server 201…

  newbieuser

  1 replies

  5 years, 7 months ago

  By: newbieuser

• SSIS 2016 having issue with Oracle Connectivity

  Hi All, I am working on SSIS upgrade project. I have upgraded SSIS 2008 package to SSIS 2016 using …

  shuxyz

  3 replies

  5 years, 8 months ago

  By: sterling3721

• SSIS won't connect to Oracle issue after ODAC driver un-install & re-install.

  Hi, I installed the ODTwithODAC1120320_32bit drivers and client and could successfully connect SSIS…

  lindsayscott23

  1 replies

  5 years, 11 months ago

  By: Sue_H

• SAME QUERY BRINGS DIFFERENT RESULT BETWEEN MSDAORA AND ORACLE PROVIDER OLE DB

  Dear All, I have one view in oracle which gives no result, and it is correct!!! ------------------…

  ggramm

  4 replies

  6 years, 10 months ago

  By: Jo Pattyn

• Cannot convert between unicode and non-unicode string data types

  I am working on an SSIS project, to pull data from Oracle 10.2g into SQL Server 2008R2, 64-bit. Thi…

  csdunaway

  14 replies

  7 years, 3 months ago

  By: RonKyle

• Oracle Linked Server query error - unable to read certain data

  We have a problem with a query from a SQL Server 2008R2 - 64bit to an Oracle Linked Server. We use …

  denappel

  9 replies

  7 years, 5 months ago

  By: raviteja.jampani36

• Need help/ push in right direction with assignment 3NF, Composite Key to SQL+

  I am working on a uni assignment so can't really take exact answers but can someone explain why I a…

  twgrops

  10 replies

  7 years, 6 months ago

  By: twgrops

• PL_SQL compares with T_SQL

  I think this is a place I can ask this question, because most  people here may know both PL_SQ…

  sqlfriend

  20 replies

  7 years, 8 months ago

  By: Sue_H

• How to get huge data from oracle to sql server most efficiently?

  Hello, Please let me know what could be the most efficient way to copy data from an oracle table (1…

  Sachin Vaidya

  1 replies

  7 years, 9 months ago

  By: Ant-Green

• SSIS hangs when reading from Oracle source

  I have a simple SSIS package.  Source is Oracle 12.  select col1, col2.,,, from oracle.ta…

  kevin bacon

  1 replies

  8 years, 1 month ago

  By: kevin bacon

• Speed up Openquery

  Can you take a look at the following Openquery to see if there is a possible way to speed it up. It…

  onemangathers

  10 replies

  8 years, 1 month ago

  By: Mr. Brian Gale