Long shot? Try this syntax on your openquery...

select * from Openquery([MyOracleDatabase],'select DateCol, to_number(to_char(Col1)) "COL1",to_number(to_char(Col2)) "COL2" from myOracleTable)'

Above mentioned syntax works fine when issuing the select statement directly to Oracle.

TheSQLGuru (11/9/2011)

---

PaulB-TheOneAndOnly (11/8/2011)

---

TheSQLGuru (10/3/2011)

---

Partitioning is an ADVANCED feature and you will very likely get yourself into unfortunate situations/scenarios if you ask for a few pointers on a forum, read a...

Michael.Gagne (11/10/2011)

---

I'm using SQL 2008 R2 and Oracle 10g. I have created a linked server (OraOLEDB.Oracle) to an Oracle database. I have a table in my Oracle database:

TableA

DateCol...

1- Confirm issue is related to the process or loading the flat files into the database.

2- Focus on the 3AM-5AM timeslot which appears to be the ETL window - everything...

logicinside22 (11/16/2011)

---

Would Suggest

Transaction Log Backup - every 15 min or 30 min.

Differential backup -Every night

FUll backup - once in a week .

system backup - once in week or...

loki1049 (11/16/2011)

---

Hello, I am having some issues in deciding how to store data taken from a specific device. The device is a spectrometer, that means it takes samples every minute....

Once again I'm in agreement with Lowell - SSMA is a fantastic tool...

geetha@in (11/15/2011)

---

As per my requirement i have to move ORACLE data (objects:tables ) to Sql server..

I shall be thankful if anyone tel me how to migrate the data from oracle...

RuanK (11/14/2011)

---

Not sure if anyone will be able to help me out.

We've got a tablespace OZFX that's relatively full. If I try to extend specific datafiles I get the following...

Any reason not to run the traditional query syntax on SQL Server side?

What happens if you do that?

I'm in agreement with...

Good! because as far as I remember we only have...

drcrelao (11/8/2011)

---

Here's my concern. I got a fact table with 10 columns (let us say column A-J). Columns A-G determines the unique set of records. Does that...

mmmhh... are we still talking about Oracle here?

Nice one.

I would probably...

1- Parse the text string picking up every single word.

2- Assign a sequence number to every single word - I think a temp table would do it...