Questions tagged [oracle-database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-2
votes
0answers
8 views

Does have any disadvantages using savepoint in oracle procedure?

I have oracle procedure that inserting 3 tables. I add savepoint begin of procedure body and when exception happens rollback to savepoint. But it is interesting and not clear to me that it is good ...
-1
votes
0answers
3 views

I have multiple tnsnames.ora files in my client machine. How to select one correct file in environment variables?

The oracle database was installed by someone and I have around 6 tns.ora files in my machine each in individual path. The files are found in Network folders inside Client 1, Client 2, Client 3, ...
0
votes
0answers
13 views

How can I forbid oracle sys user accessing other users' tables?

I'm learning oracle database, I want to know how can I forbid sys user accessing other users' tables, and after I achieve this, can I make sys user to re-access other users' tables?
1
vote
0answers
5 views

Python library to parse SQL create statements

I have a requirement of reading Oracle create statement in a file and gather all Metadata (Table name, column name, its datatypes etc). I have tried following but no luck so far: 1) Used twextpy (pip ...
0
votes
0answers
4 views

Software to create form and report to work with oracle database

i've a unix server with oracle server and apache http server on it. i need to develop some report and some form to data insert inside oracle database. which is the best fast software to do this? i ...
0
votes
0answers
6 views

Compare an Oracle database with a Postgresql database

We are currently migrating an Oracle database to a Postgresql database. However, the Oracle database is huge and we want to check the quality of the migration. Do you know a tool that can compare an ...
0
votes
0answers
13 views

Kafka Connector for Oracle Database

I want to build a Kafka Connector in order to retrieve records from a database at near real time. My database is the Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 and the tables have ...
1
vote
0answers
11 views

Replacing Oracle Discoverer

Oracle Discoverer as been discontinued by Oracle. Oracle suggests to switch to BIPublisher but it seems to be to expensive and a bit to much for what we need. What we really need is a opensource or ...
0
votes
0answers
9 views

Hosting Oracle DB in Google Cloud Platform as Managed Service

I need to host host a Oracle DB in Google Cloud Platform as managed service. I believe, the GCP support MySQL and Postgress-SQL as managed services. I am not sure about how the same can be achieved ...
1
vote
0answers
7 views

How can I periodically transfer data from my local Oracle-XE database to a remote Oracle 11g?

Here's my use case: In order to speed things up in my real time application, I came up with the idea of using Oracle-XE as a local cache database for faster access & then somehow transfer (...
0
votes
0answers
8 views

Please suggest some light weight Open source library which support oracle db interaction and can execute queries and procedures?

I want to use some light weight libarary which connects to oracledb with with pooling option and able to execute select,update,insert procedures and transactions. I have explored knex.js but ...
0
votes
1answer
19 views

Are there any main differences between MySQL (MariaDB), PostgreSQL, Oracle, Microsoft Databases for usage in enterprise? [closed]

Lets take this: Company using Microsoft Server Database since 2008. Its company what heavily depends on working with data from databases. (Construction company ) Current database is outdated and not ...
0
votes
3answers
294 views

Is there alternative to SQL Developer that supports PL/SQL too?

I found Oracle's SQL Developer hard to setup, so I would like to use something easier, but with support of the same language or maximally close, preferably free (GNU) and preferably available for ...
0
votes
0answers
23 views

DB replication from 5000 sites to head office

I need to replicate certain sets of data from a master database site (head office) to multiple sites geographically distributed. There is no specific software chosen yet for head office or the remote ...
1
vote
0answers
16 views

Program not from Oracle that can read Oracle export dumps?

I am maintaining an Oracle database. Recently, my boss asked me what would happend if we for some reason suddenly could no longer use Oracle products. So I am now looking for some kind of software ...
0
votes
1answer
51 views

Tool for migrating oracle table to CSV file

I want to migrate data from oracle table to a csv file. Is there any tool for this migration?
3
votes
2answers
131 views

How to document (describe in HTML) Oracle schema?

I'm trying to find a tool (or simple program, script, jar file) to describe my oracle database (schema). What I need from output report: HTML format ER diagram in output Table and Columns ...
0
votes
0answers
17 views

Converting create table statements from Oracle SQL to PostgreSQL

I am looking for a program that can converting create table statements from Oracle SQL to PostgreSQL (e.g., choose the closest type for each column). Any OS, any license, any price is fine. CLI or ...