Q&A BY TAG 'oracle'

You must sign in to ask a question. If you do not have an account, you can register here

Fail to connect VDP Admin tool to a sgbd Oracle, running in a training virtual machine named DQVM.
answered 31-07-2020 04:07:13 -0400

Hello, I try to connect VDP Admin tool to a sgbd Oracle, running in a training virtual machine named DQVM. A screenhot is joined for illustrate, the error message is (ORA-12505, TNS:listener does not currently know of SID given in connect descriptor )...

Answers: 2

DQVM Oracle

Data type mapping
answered 03-01-2019 08:04:42 -0500

Hi, Happy New Year I have been asked to produce a data type mapping from Oracle to Denodo. I can't figure out what happens, for instance to integers: In Oracle an integer would be a Number(38), so -999..(38 9s) to 999... In Denodo the Int data type h...

Answers: 3

oracle datatype

Interpolation of function and variable.
answered 26-09-2018 08:27:23 -0400

I have a connection to an Oracle database. In the connection we set up several Driver Properties including the user name which the database uses to pull only the rows the user executing the query has access to (row security). That property is set up l...

Answers: 1

Function Interpolation Variables oracle

How to change database schema of Oracle base views
answered 07-05-2018 11:39:27 -0400

Hi, in our development system (denodo 6.0, latest update) we frequently want to change the database schema of many existing base views belonging to the same Oracle data source. The problem is that the schema name is included in every JDBC wrapper, fo...

Answers: 1

Denodo 6.0 JDBC oracle wrapper

How can I create an Oracle DB Link to Denodo?
answered 07-04-2015 04:48:31 -0400

Dear Denodo, How can I create an Oracle DB Link to Denodo? I see in the Denodo 5.5 Update 20150319 VDP Release notes that you fixed bug #20859. I didn't even know that we could create an Oracle DB link into Denodo. How do I create this DB link from...

Answers: 1

oracle

Slow performance when joining tables from oracle database
answered 28-11-2014 05:48:16 -0500

Two issues related to vql performance. I am connecting to a oracle 12c database and trying to query a record from huge table. Denodo is not returning records . I am testing joining two oracle tables using the base views . The performance of the query ...

Answers: 3

oracle Sql performance

How can we insert rows with a sequence generated primary key?
answered 10-10-2014 01:07:01 -0400

We would like to do POST requests to Denodo 5 webservices without including a primary key in the HTTP body/document and then have oracle generate the primary key based on a sequence. The equivalent SQL statement we are trying to mimic in Denodo is: ...

Answers: 2

rest sequence oracle primary keys