Questions tagged [oracle]

All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.

1,159 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
2k views

Migrating from Oracle to MySQL using WorkBench Migration Tool

I am currently migrating from Oracle to MySQL and I am going to use the migration tool in workbench to help me with the procedure. I have entered my source connection details as follows: Database ...
2
votes
0answers
2k views

What is the nature of “LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2”?

I'm not sure when this started, but for the time being the primary database instances in a physical standby configuration logs this message on every redo log switch. *********************************...
2
votes
0answers
899 views

oracle streams apply: how to get a reason why LCR message was not applied

I've set up bidirectional oracle streams replication (11gR1) using identical scripts on both machines (DB1 and DB2). Although changes from DB1 are being applied to DB2, changes from DB2 to DB1 aren't. ...
2
votes
0answers
2k views

Connection to MS Access from Oracle over a DB Link

I need to establish a connection between a MS Access database, which is placed on a network share on a windows box, and an Oracle database on a Unix Box. I need to query the Access tables from the ...
2
votes
0answers
212 views

XML parsing failed

I'm using a query on a oracle db which extracts values from clobs using the xmltype function and an xpath. Unfortunately the query fails and reports a 'XML Parsing failed'. I assume that one of the ...
2
votes
0answers
1k views

ORACLE SSL using Microsoft Certificate Store for PKI

I am trying to set up PKI SSL authentication between client and server using a Microsoft Certificate Store. Client: Windows 7 64 bit with Oracle client 11.2.0.3.0 Server: Windows 2008 R2 64 bit with ...
2
votes
0answers
4k views

Convert the Highvalue of user_partition in varchar2

I have a requirement where I would like to use the HIGH_VALUE field of user_partition table as a Varchar2 or TimeStamp value and I would like to get it used as a Function in SQL Query. Something like ...
2
votes
0answers
483 views

Reconfigure the registry for new Oracle installation

I have the following oracle homes installed on my Windows machine Oracle Developer Suite Oracle Discoverer Oracle 10G Client I installed Oracle 10G database manually by following the following steps ...
2
votes
4answers
3k views

Select unique records from multiple records based on max date

I have table like below +----+----------+-----+-------------+--------+ | ID | ADDR | IND | update_Date | Sq_NBR | +----+----------+-----+-------------+--------+ | 1 | PHYSICAL | Y | 11-Oct ...
2
votes
1answer
2k views

Environmental Variables for OracleDB 12 in Oracle Linux are Overriding Each Other with SQLPlus Variables

I want to set the environmental variables for OracleDB and SqlPlus properly. However, they are overriding each other. I'm doing something wrong, and I would like to get a hand finding where I went ...
2
votes
1answer
1k views

Opening an Oracle database with a corrupted redo log

I have a database that is not open. And I have a redo log that is corrupted. What would be the best way for me to open the database? This is a testing db and I am not concerned with data loss - but I ...
2
votes
1answer
523 views

Oracle user locks (dbms_lock): guaranteed order of requests granted?

I was wondering if Oracle guarantees that the sequence of dbms_lock.request granted is the same as the sequence in which they were requested. In my tests it always was the case, but I couldn't find ...
2
votes
1answer
1k views

Failed to drop column - value too large

I'm trying to remove column from DB and got a strange error: Error starting at line 147 in command: alter table config drop column dte Error report: SQL Error: ORA-12899: value ...
2
votes
1answer
708 views

Oracle Text - Changing SYNC to MANUAL not working always

Oracle version is 11g. When the Oracle Text index is created, SYNC option is given as "ON COMMIT". Before inserting large number of records, SYNC is changed to "Manual" for performance reason. Below ...
2
votes
2answers
15k views

Arabic characters not displaying in oracle database

We have a Oracle database 8.1.7 running for many years on Win-2000. We wanted to move the database on a newer machine running Win 2003. I did the following I made a cold backup of old database. ...
1
vote
1answer
74 views

Oracle MV requires object type to be defined as FINAL?

I want to create an Oracle 18c materialized view (MV) on a table that has a user-defined datatype called ST_GEOMETRY: The MV would do a COMPLETE refresh on a schedule — on a local table. Some info ...
1
vote
0answers
22 views

Oracle Scheduler Job - Exporting of CSV File every 16:01

I have already executed the code for scheduler. However, I have a problem whenever I execute my scheduler. Can someone help me with this? I'll appreciate all your response. My procedure code: create ...
1
vote
1answer
27 views

Is it possible to duplicate a standby database on the fly?

Can I duplicate a standby database on the fly? Currently, I'm getting this error: RMAN-03002: failure of Duplicate Db command at 01/08/2021 01:55:58 RMAN-05501: aborting duplication of target ...
1
vote
1answer
27 views

Comparing records from same table and deleting the old ones

Greeting, I have a beginner experience with programming in Oracle PL/SQL. The problem I am trying to solve is that in a hypothetical situation, I want to compare records in the same table based on the ...
1
vote
0answers
49 views

SQL*Plus fail instead of prompting for substitution variable

Imagine a file test.sql with the following content SELECT '&myvar' AS greeting FROM dual; When we run that file in sqlplus. We will be prompted for the value of the variable &myvar since it's ...
1
vote
1answer
42 views

Defining OLAP or OLTP on table level in Oracle/postgres/SQLserver

Usually companies have separate databases for OLTP and OLAP (Row stores and column stores) where data is loaded through ETL jobs to another database for analytical processing. I am particularly ...
1
vote
0answers
83 views

Oracle 19 in Docker (WSL2) is much slower than a native Oracle 12 install on Windows

I am attempting to run Oracle 19 inside a Docker container on Windows, but despite the usage of WSL2, I am still seeing an 80% drop in performance as compared to a natively installed Oracle 12 ...
1
vote
1answer
18 views

How to configure Oracle traffic director for full site failover to have high availability?

I have two server systems, each server having both Apache Tomcat server (deployed web app) and Oracle 11g database server. The database on the two servers is synchronised by Oracle Data Guard for high ...
1
vote
0answers
70 views

WSL2 Docker Oracle volume mapping: how to switch from Windows to Linux file system

I am running Oracle (V19, V18, and V12) instances under WSL2 (Windows 10 version 2004). For persistence, my Oracle data files are mapped to a folder on my Windows host. I can run the containers from ...
1
vote
0answers
37 views

Recursively list dependencies / references of a stored procedure

I'm trying to import a subset of our production dump with impdp for our local development database running on Oracle XE. To find out what other objects I have to import for a particular stored ...
1
vote
0answers
31 views

oralce import joinning 2 tables using query

Is it possible to join 2 tables inside the query in oracle while importing ? I have a dump for 2 tables tab1 and tab2. and I am trying to query on 1 of the tables: Directory=backup DUMPFILE=twotables....
1
vote
1answer
33 views

See content of temporary Table in Oracles' EXPLAIN

I'm executing a Query in Oracle SQL Developer and eventually call SELECT * FROM TABLE ( dbms_xplan.display ); to get an impression what Oracle just did. There's a column Name in the output that ...
1
vote
0answers
123 views

Anomalous performance of mass INSERT in Oracle

Can you please help me diagnose, explain, and possibly solve the problem of unstable peformance of mass insertions in Oracle? I need periodically to load large amounts of data into an Oracle database. ...
1
vote
0answers
25 views

How to configure TCPS in JDBC thin client for oracle

An Java Application running with JDBC thin wtih TCP connection, Now require is to convert in TCPS for encryption transmission from application to database. String url = "jdbc:oracle:thin:@(...
1
vote
0answers
31 views

Oracle error 43914 in CASE WHEN expression: arguments have undefined collation

I want to know which is the difference between this query: SELECT * FROM TEST_TABLE WHERE CHAR_FIELD = CASE WHEN KEY_FIELD = 'Q' THEN 'M' ELSE CASE WHEN KEY_FIELD = 'T' THEN 'K' ...
1
vote
0answers
60 views

Reduce file header block

I'm in the middle of my first Statspack analysis, and one of the most time consuming events is Buffer Busy Waits (around 30% time). I checked out the Buffer Wait statistics, and it seems like the most ...
1
vote
0answers
14 views

Transaction log file - Migration SSMA

I'm attempting to migrate a relatively large Oracle DB to MSSQL using SSMA however due to disk space constraints, I had to stop the full migration last night when it was 50% of the way through. Upon ...
1
vote
0answers
82 views

oracle sqlcl and sqlplus - seperate login.sql on linux

I feel I'm probably missing something obvious here, but I can't see an easy way to have a separate login.sql for sqlplus and sqlcl This is problematic for me as the errors thrown up by sqlplus for the ...
1
vote
1answer
36 views

Selecting a record based off conditions CLOB

I have a table with a column storing JSON data as a CLOB. The JSON has a 'miscData' field that is made up of an array of JSON objects. Each object has 2 keys which are always the same, but the values ...
1
vote
0answers
50 views

Using virtual columns to implement an exclusive arc relationship

At the risk of bringing up an often discussed question, I wanted to get some feedback on using virtual columns (specifically Oracle 12c+) to implement an exclusive arc relationship. The database ...
1
vote
0answers
55 views

How can I write procedures that I can loop over to insert a series of files into my database?

My goal: Insert a series of csv files into my database by creating procedures for each individual table and then looping over them. My csv files will all be named very similar to this: ...
1
vote
1answer
35 views

Oracle multiple databases only able to access one database

I am new to oracle. I've installed oracle 12c(required to be this specific version) in my windows pc with no problem. I created one database named LOCAL using Database Configuration Assistant. Then i ...
1
vote
0answers
49 views

What is Oracle's Window Buffer Operator?

Oracle database's explain plan sometimes includes Window (Buffer). What does this operator do? Here is the SQL. The primary keys are RECORD_DATE, TYPE and KEY. select source.RECORD_DATE, ...
1
vote
0answers
69 views

Insert/Update table on Pentaho when the table has a TYPE defined by user

I'm trying to make a remote connection from computer A to computer B where they have the same database but computer B doesn't have data in the table PERSONA_Y_ESTADOS, the goal is to get 3 rows from ...
1
vote
0answers
49 views

Oracle to PostgreSQL Migration Changed Data Capture

We are currently migrating our application back end from Oracle to Postgres and my concern/query is that in case we face issues post migration, in a worst case scenario we may need to revert back to ...
1
vote
0answers
43 views

Unit Testing ORDS - Oracle Rest Data Services

I've been wanting to develop some unit tests for my ORDS functions as part of my push for better CI/CD - I am running ORDS functions on an Oracle Autonomous Database 19c, and while I'm developing a ...
1
vote
0answers
46 views

Oracle - Monitoring tablespace warnings and critical events via Microsoft Windows Event log

I would like to monitor tablespace warning and critical events of my Oracle database (12c Standard Release 12.2.0.1.0) via Microsoft Windows Event Viewer and attach tasks to it. Right now only a few ...
1
vote
1answer
739 views

Oracle19C installation is stuck at executing datapatch in Windows 10 using dbca

I tried using dbca. There are no errors. It just hangs. I tried leaving it running for 4 hours. It is always stuck at 36% even after multiple tries. Logs: [progressPage.flowWorker] [ 2020-05-25 00:...
1
vote
1answer
115 views

Failed to start service, error 2. TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error

i have start oracle services but its giving error: windows could not start the OracleOraDb11g_home1ClrAgent Service on local computer. Error2: the system cannot find the file specified. Also there ...
1
vote
0answers
38 views

Pivot rows to columns in Oracle where number of rows-to-columns can only be determined at runtime

Using Oracle 18c and given the following table and data: create table food (type varchar2(20), name varchar2(30)); insert into food values ('fruit', 'apple'); insert into food values ('fruit', 'pear')...
1
vote
0answers
50 views

How do I configure Oracle DB 11g Enterprise to be able to be accessed from HTTPS PORT?

I'm trying to create a TSA Listener so I could access my Oracle database from HTTPS Port. I already checked edelivery.oracle.com but I found no Web Tier for Windows. Is there any other way for me to ...
1
vote
1answer
1k views

Oracle SCN_TO_TIMESTAMP (ORA_ROWSCN) fails

Trying to run the following SQL which is basically an exact copy of an example I have seen on multiple sites, showing how to do this (I just change the tablename) SELECT SCN_TO_TIMESTAMP(ORA_ROWSCN) ...
1
vote
0answers
32 views

What's a process for determining table links?

I need to make several queries to get information out of our Oracle 12c database. I've used oracle SQL Developer to determine primary and foreign key relationships, but how do I link tables when there ...
1
vote
0answers
90 views

How to trim trailing spaces from headers in Oracle 12.1 SQLPLUS

I am creating a pipe-delimited file from a SQLPLUS query (Oracle 12.1), and the recipients are requesting that I trim the trailing spaces from the header entries. That is, the current output file ...
1
vote
1answer
594 views

Oracle goldengate service is not starting: Failed to retrieve the name of a missing Oracle redo log

I am trying to start GG service, when try 'start my_service' then starting but it didn't start, status is changed always starting to stopped. I need to start goldengate service.. I don't know what ...

1 2
3
4 5
24