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
1
vote
2answers
1k views

how to solve ORACLE AUDSYS.SYS space error

I am having this problem "Warning: odbc_connect(): SQL error: [Oracle][ODBC][Ora]ORA-02002: error while writing to audit trail ORA-55917: Table flush I/O failed for log ID: 1 bucket ID: 0 ORA-01691: ...
1
vote
0answers
24 views

Using Merge in Oracle to update a table and clear out a field if the record is not in the source table

I need some help converting an MSSQL Merge statement into Oracle MERGE INTO A USING B on a.a_id = b.b_id WHEN MATCHED and isNull(a.a_field, '') <> isNull(b.b_field,'') THEN UPDATE SET a....
1
vote
0answers
74 views

Is it possible to alter normal column to virtual column in Oracle?

ALTER TABLE TAB_NAME ADD TEST_COL VARCHAR2(255); ALTER TABLE TAB_NAME MODIFY TEST_COL GENERATED ALWAYS as ('some_exp') VIRTUAL; Second script gives an error: Error report - ORA-54026: Real column ...
1
vote
0answers
48 views

Why my Oracle 12C is allowing me to a connection creation without passing network security and integrity parameters

My Integrity settings Oracle Net Manager are: -- Integrity for - Server Checksum level - REQUIRED Selected Method : SHA1 -- Integrity for- CLIENT Checksum level - REQUIRED Selected Method : SHA1 ...
1
vote
0answers
154 views

Does SQL Server 2017 Express support Linked Server connections to Oracle DB

Is there any restrictions with "Linked Servers" with SQL Server 2017 Express? Vs using SQL Server 2017 Standard. Only in regards to "Linked Servers".
1
vote
0answers
89 views

Oracle Context Index - finding unsynchronised records

Context indexes can be update with the procedure: Ctx_Ddl.Sync_Index (index_name); But what exactly is synchronised by this function? How does Oracle know what is unsynchronised (i.e. how does it ...
1
vote
0answers
100 views

Database - limit of reading a table with a lot of concurrent batch read and writes

We have this table. It contains data which will be picked up by an hourly batch job for processing. Five times a day, there are also multiple batch ETL jobs which get data from other source table and ...
1
vote
0answers
277 views

EM Daemon is not running

I have installed Oracle Database 11gR2 on OS Oracle Linux 7.7 while i try to start server using below command its started [oracle@localhost dbhome_1]$ emctl start dbconsole Oracle Enterprise Manager ...
1
vote
1answer
107 views

can I do a restore controlfile from autobackup out FAST RECOVERY AREA?

I know that I can issue the command restore controlfile from "location_here". But there is some config that can I do for issue the command restore controlfile from autobackup even whether the ...
1
vote
0answers
506 views

Oracle 12c Datapatch Error

We have an old Oracle 12c database server that is not up to date (version 12.1.0.1.0). Unforunately a full version upgrade is out of scope right now, but I was hoping to at least apply the latest ...
1
vote
0answers
24 views

Can multiple process pull off the same record from an Oracle FIFO queue?

My understanding of Oracle AQ (Advanced Queuing) is that no two (or more) processes can pull off (drain/consume) the same record of an Oracle FIFO queue. Is this correct or is some code needed to ...
1
vote
0answers
76 views

ORA-02063 Encoding problem with Oracle querying SQL Server through ODBC link

We have a problem querying some data from the SQL Server from the Oracle database with the ORA-LNX connecting to SQL-SRV using ODBC and Heterogeneous Service (Oracle HS). When we send the query ...
1
vote
0answers
650 views

Connecting to SQL Server 2017 from Oracle SQL Developer

Pretty much as the title says, has anyone tried connecting to SQL Server 2017 via Oracle SQL Developer? I downloaded the latest jTDS (jtds-1.3.1-dist) but this only seems to support SQL Server 2012 (...
1
vote
0answers
75 views

oracle 11g select distinct issue

I have a big table (61mil rows) that has an indexed not-null column ID. I want to select the distinct values of that column. I expected the select distinct id from bigtable ; to run fast, making ...
1
vote
2answers
364 views

Suppress some output from PL/SQL script in Toad for Oracle

Question: In PL/SQL for Oracle running in Toad, can I suppress script output except for certain lines I want to see? e.g. I don't want create table, insert record, drop table. I do want my own ...
1
vote
0answers
19 views

Oracle 12c - Installing SW with an Active Directory Account on RHEL7

My client insists on installing Oracle using an Active Directory Account as the SW owner instead of creating a local oracle service account on RHEL7. I'm opposed, but willing to be flexible to meet ...
1
vote
0answers
445 views

How to truncate a table without locking it?

I have a SYSTEM's table AUD$ in ORACLE's database that is constantly being populated (whenever a DB user logs in to DB - a records is written to AUD$). The table AUD$ has like 100 million records (...
1
vote
3answers
118 views

Compare 2 columns in 2 different tables with non uniques values

I want to compare and check whether the values in columnA of table A exist in column A of Table B. But the columnA consist of duplicate values in both the table.
1
vote
1answer
196 views

Why is OracleDB locking up in Docker?

I am trying to set up an Oracle database in Docker, and once the database is up and running, I can exec into sqlplus just fine, but if I try to connect with another application like Oracle SQL ...
1
vote
0answers
31 views

Oracle 12C silent installation - response file

I am installing Oracle 12c using a response file. The installer exits after a while, with the following error message: ERROR: Cannot add user to application access ACL. No mapping between account ...
1
vote
0answers
33 views

What is “direct client connections” to Oracle?

The Oracle document states: A read/write database instance, which is the default, can process DML and supports direct connections from client applications. In contrast, a read-only database ...
1
vote
0answers
28 views

How does Oracle authenticate a user?

I'm learning Oracle and below is my testing of starting up an Oracle instance and make the database available. oracle:[~]$ sqlplus SQL*Plus: Release 19.0.0.0.0 - Production on Mon Aug 5 09:29:30 ...
1
vote
0answers
144 views

Why did my index become unusable after setting MAX_STRING_SIZE to EXTENDED?

I run Oracle Database 12c Standard Edition Release 12.2.0.1.0, and followed the official documentation to set MAX_STRING_SIZE to EXTENDED, to be allowed to use more than 4000 bytes in a VARCHAR2 ...
1
vote
0answers
33 views

SSRS: Oracle Data Sources Breaking After Server Updates\Restart

Our SSRS instance has several Shared Data Sources that hit Oracle databases. Whenever we do patching or the server restarts, these Data Sources seem to break. Any reports hitting them come up with the ...
1
vote
1answer
53 views

Oracle Materialized View - Is it Safe to Use Only ROWID as Record Identifier?

this is a question related to Oracle 12c. I'm currently trying to create MVs as data sources for Golden Gate replication. We need fast refresh because We have to replicate 60,000 rows + at one time ...
1
vote
1answer
52 views

Give me suggestion about backup of schema and full backup in oracle

I need your help about backup in oracle database. Currently I am using Export Utility of Schema Backup but taking more time to complete and size is 40GB. For full database backup using Image Copy and ...
1
vote
0answers
94 views

Oracle 12.2 shows high parse per execution ratio for unknown lob$ query

In an AWR report I see the following (most liekly recursive) query which happens very often and is parsed each time: select obj#, intcol#, ts#, file#, block#, property from lob$ where lobj#=:1 The ...
1
vote
1answer
48 views

Cannot export SELECT result as expected

I noticed this issue when exporting the Oracle SQL execution result from Intellij. The database version is: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production. My SQL is ...
1
vote
0answers
231 views

Start dbms_services on standby database

I'm developing a trigger which starts and stops services when the pdb is open. The point is that my trigger doesn't stop the service if I execute the ALTER PLUGGABLE DATABASE ALL SAVE STATE; with ...
1
vote
0answers
47 views

Cannot get the new table's FK-constraints in an AFTER ALTER trigger

I'm trying to create a trigger for AFTER ALTER event on schema's tables which would work with the new FK-constraints, here's my test code: CREATE OR REPLACE TRIGGER Test_Trigger AFTER ALTER ON SCHEMA ...
1
vote
0answers
730 views

How to solve problem when oracle apex does not let me do anything with my created schemas even though I should have privileges?

I have a problem with with latest version of APEX, I have installed it on my pc, i logged in as and admin created workspace with schema, but when I log in to that workspace as a user with admin's ...
1
vote
0answers
57 views

Cronjob to check when Oracle Materialized View was last updated?

I have two database users in my Oracle DB and want to create MV's in User B which get their data from User A through a database link. I plan to autorefresh the MV's every night but want to make sure ...
1
vote
0answers
86 views

Operation CTL_BOOTSTRAP canceled during phase 0, error = ORA-408

I am currently testing a data guard environment. In the alert.log of the broker I always see the following message after a switchover: 2019-05-23 08:08:54.716 7fffffff 0 Operation ...
1
vote
1answer
3k views

Oracle losing connection ( ORA-03114 ) after some time not using the software

After some time idle, if users try to use the our system, we receive the error: ORA-03114 - not connected to Oracle. I know there's a parameter called SQLNET.EXPIRE_TIME. the recomendation is ...
1
vote
0answers
478 views

Oracle 18 on Windows with long hostnames doesn't talk to the local listener?

Note: Initially this was about installing Oracle 18c XE on a Windows machine with a long (> 15 chars) hostname. During our further tests we then noticed that Oracle 18c XE does not work properly at ...
1
vote
0answers
267 views

OCI KBHS-00719: Error 'unknown'; Archived object is not restored

I am encountering below error message from RMAN backup to OCI. Either the bucket named 'DB_BACKUP' does not exist in the namespace 'UNIcredits' or you are not authorized to access it. KBHS-01404:...
1
vote
0answers
2k views

Oracle listener give “Message 850 not found; No message file for product=network, facility=NL”

I'have just completed oracle 11g database software installation on Linux. I launched netca and configured a listener. As soon as I try to run lsnrctl I get the following error. [oracle@lnx-db ~]$ ...
1
vote
0answers
102 views

Is there a way to open an encrypted Oracle Database wallet through weblogic JDBC drivers?

I encrypted a column in an Oracle 12c database using the TDE method, The said column was being used in my application, The column becomes unavailable due to the Database wallet being closed. To open ...
1
vote
1answer
36 views

Oracle: procedures+functions code base not overlapping package body code base

I intend to find all code in my database containing some string. I run a query such as: SELECT DISTINCT name, type FROM all_source WHERE UPPER(text) LIKE UPPER(‘%string%’); and a lot of results, let'...
1
vote
0answers
129 views

rman backup takes too long time on oracle 10g

I have a problem that my RMAN backup on our sl45 tape drive takes 2 days to backup 450GB database. The problem that the log shows is that the backup waits too long between finishing a certain task and ...
1
vote
1answer
76 views

Oracle AWS package errors when removing user

We are getting the folowing error when attempting to remove a user from our 11g Oracle. a dump from an Amazon DB was (failed) imported, and now we see this. ERROR at line 1: ORA-00604: error occurred ...
1
vote
0answers
775 views

Cannot access remote table after parallel/insert direct load txn

This is the Oracle error message I'm getting ORA - 12840. We just upgraded from 10i to 12c version and some of the processes aren't working as they did before. I get this error when I execute a CREATE ...
1
vote
0answers
37 views

Using conditions to return specific rows

From the following table i am trying to retrieve specific rows based on a criteria +----+--------------+------+ | ID | UPDATED_DATE | TYPE | +----+--------------+------+ | 1 | 01/13 | P | |...
1
vote
1answer
232 views

Is it possible to show DML that is locking some table?

I already saw here how I can list my locked objects. Suppose I, using PL/SQL Developer(pink cylinder logo one), run select * from someTable for update and didn't commit nor rollback. Now using the ...
1
vote
1answer
46 views

Is it possible to login to an Oracle schema using a certificate?

The question is based on having to deal with lots of automated processing (testing, mostly). As it stands, all the schemas used have the same well known password, which is stored in lots of ...
1
vote
3answers
394 views

Move expdp part file before job end

I have an Oracle 11gr2 database running on Enterprise Linux 6.6 server. I use the following command to split the expdp dump file to 10G size chunks: expdp userid=/ DIRECTORY=dmpdir dumpfile=dump%u....
1
vote
0answers
53 views

Different operations in different databases

So I have just executed EXPLAIN PLAN FOR on the same query in two databases that I've been told are identical in every regard except for slight variations in data amount. And the result of it seems ...
1
vote
0answers
36 views

Checking if schema name is included in every sentence

I got some oracle database scripts for creating the whole database of an application, including sentences for creating tables, sequences, synonyms, inserts and updates of data, etc I need to ensure ...
1
vote
0answers
593 views

What are the advantages of using a Materialized View directly on a table?

Recently, in enterprise's Oracle database, I have seen some materialized views that filter directly columns of table without adding aggregate fields and without calling custom functions. Example: ...
1
vote
1answer
34 views

Is there any other way to replace cursor for the following scenario

Table IA Id Status Details 1 open aaa 2 close bbb 3 open ccc 4 open ddd 5 open eeee 6 open ffff 7 open gggg 8 close iii 9 close hhh 10 ...

1 2 3
4
5
24