Have you also set ORACLE_HOME and ORACLE_SID environmental variables?

Can you PING the server using the same value you have on TNSNAMES.ora file?

Can you TNSPING the instance if you fully qualify...

Could you please post the schema of the table? I'm curious about the datatype of date_c and time_c columns.

lewis.ray (1/25/2013)

---

I am having a problem connecting to an oracle database using oracle8 client.

It is installed on windows7.

I have the same tnsnames.ora and sqlnet.ora files as everyone else here.

The only...

5280_Lifestyle (1/25/2013)

---

Thanks for the reply. I took a good look over the function and what its output was supposed to be and how it plugged into the view script. I...

sstacy7 (1/24/2013)

---

How do you get the most recent record ie it would be 150 for acct 1 and 75 for acct 2.

CREATE TABLE [dbo].[Table_1](

[Acct] [int] NULL,

[Amt] [int] NULL

) ON [PRIMARY]

INSERT...

A tab for each WHERE, a row describing each WHAT

markusstar (1/24/2013)

---

thank you, makes a lot more sense now

I am also looking to implement a policy that will prevent people from creating objects in schemas that don't exist, and I...

markusstar (1/24/2013)

---

I am trying to create a policy which will force my backups to all be placed in a specific filepath not sure how to do this. any help would...

lg123 (1/24/2013)

---

Hi,

I want to export some tables from sql server 2008 to oracle 11g. I am planning to use SQL Server Import and Export tool available in SSIS, SQL Server....

5280_Lifestyle (1/24/2013)

---

I've migrated some Oracle databases into some SQL Server databases and now I'm working on building reports from the Oracle queries. Some of the queries reference views, which, in...

(substantial platform differences) = (substantial performance differences)

Chrissy321 (1/23/2013)

---

On my production server I am getting hundreds of inserts per second. In my test environment I am getting 1 insert every 1 or 2 seconds. Granted my test...

Hi Jim --

if you are confident the issue you are experiencing is the same one described on kb/934396 then I would carefully consider applying the resolution procedure documented in such...

JC-3113 (1/22/2013)

---

once in a while i get this error:

error 18210 severity 16 state 1 operating system error 995

it looks like the backup file was created, but I am not sure...

dwain.c (1/22/2013)

---

m.rajesh.uk (1/22/2013)

---

In my test enviroment i found that out of 269 tables 99 tables does not have primary keys and 4 tables having 2 primary keys . can...