Working with Oracle

• Topics

  Started by

  Posts

  Last post

• ORACLE to SQL SERVER Code conversion problem

  We are converting ORACLE to SQL Server and I need help with to_date, to_char and sysdate in the 2 o…

  jbrewer

  3 replies

  13 years, 1 month ago

  By: jbrewer

• Oracle -Microsoft cluster service(OS CLUSTERING)

  I need to install a MSCS (microsoft cluster) over 2003 standard server - two ms boxes A & B. T…

  ebenraja

  3 replies

  13 years, 1 month ago

  By: rfr.ferrari

• PIVOT in oracle--Code Correction

  select * from ( select prod_code from UNICA.DSI_SUBS_STOP_START_DRW ) pivot ( count(prod_code…

  varunkum

  2 replies

  13 years, 1 month ago

  By: varunkum

• Date conversion error with dynamic SQL and Update OpenQuery

  I have been racking my brain on this and I hope it's something simple to fix. I have this first que…

  J.O.

  2 replies

  13 years, 1 month ago

  By: sherifffruitfly

• Oracle Linked Server Connection Error

  We have a SQL 2005 server with a linked server to an Oracle 10g database and a job that runs every …

  Mike Reigler

  2 replies

  13 years, 2 months ago

  By: Mike Reigler

• SSIS For Sql server what for ORACLE ?

  I have been working on SSIS SSRS projects more than 3 years. Now i wonder how to develop similar pr…

  sirzatkoc

  3 replies

  13 years, 2 months ago

  By: VioletMauger0771

• Can't establish connection to Oracle

  I'm trying to set up a linked server from SQL Server 2008 R2 64 bit to Oracle 7.2. I have a working…

  Sioban Krzywicki

  7 replies

  13 years, 2 months ago

  By: Sioban Krzywicki

• Unable to connect to Oracle - failed with error code 0xC0202009. Description: "ORA-01017: invalid username/password; logon denied

  Hey all, At a bit of a loss here. I setup a connection for Oracle in SSIS using Microsoft OLE DB Pr…

  Adam Bean

  13 replies

  13 years, 2 months ago

  By: PaulB-TheOneAndOnly

• Do you know any website like SSC but for Oracle DBA

  All Need to find a good web resource for Oracle DBA, Do you know any one? Thank you.

  BlueTiger

  9 replies

  13 years, 2 months ago

  By: BlueTiger

• how to install ODAC component on SQL Server 2005 Cluster enviornment

  want to install odac on cluster enviornment on SQL Server 2005

  gajananhatkar

  1 replies

  13 years, 3 months ago

  By: PaulB-TheOneAndOnly

• Error Msg:ora-00933 sql command not properly ended

  Hi Guys, I have a query and i am getting frustrated not being able to understand where the issue is…

  arun_anand09

  4 replies

  13 years, 3 months ago

  By: Jo Pattyn

• Can't see table in Oracle

  Greetings all. I just realized there is an express version of Oracle, so I thought "why not get it…

  Greg Snidow

  4 replies

  13 years, 3 months ago

  By: PaulB-TheOneAndOnly

• SSIS 2008 R2 Oracle Connection Error

  Hello everyone, I created an SSIS package with an OLEDB source connected to Oracle 10g using the "O…

  venus.pvr

  9 replies

  13 years, 3 months ago

  By: venus.pvr

• Updating data from one table in Database A to another table in Database B and schedule the update everyday

  Hi guys, I need to update data from one table in database A to another table in database B. The re…

  jock.kevin10

  8 replies

  13 years, 3 months ago

  By: Welsh Corgi

• IMP-00058: ORACLE error 1658 encountered on tablespace users -some pointers/advice needed

  I'm posting this here cause on the OTN-forum I'm getting nothing but grief and no real help. I'm do…

  Resender

  1 replies

  13 years, 3 months ago

  By: PaulB-TheOneAndOnly