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.

Filter by
Sorted by
Tagged with
0
votes
0answers
11 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: ...
0
votes
1answer
13 views

Why am i getting “missing right parenthesis” error when i try to LOG ERRORS when loading from an external table?

I've successfully created an error logging table BEGIN DBMS_ERRLOG.create_error_log( dml_table_name => 'enzyme', skip_unsupported => TRUE); END; / desc ERR$_ENZYME; Name ...
0
votes
2answers
47 views

Can't start Oracle after Virtual Machine restore

As part of a project for a customer of mine, they've given me the complete backup of a physical server (taken by Veeam) which I have then used to make a Bare Metal recovery onto a test VM host I have ...
0
votes
2answers
54 views

ORA-01031: insufficient privileges, cannot login as any user

I ran below command and restarted docker container. alter system set processes = 1 scope = spfile; after this I am not able to login to DB at all. root@30b2f9030f89:/u01/app/oracle/product/11.2.0/xe/...
0
votes
1answer
19 views

AWR dbms_workload_repository ash_global_report_text extract text from output

I want to build a scheduled job in Enterprise Manager to trigger every hour the following query: SELECT output FROM TABLE(dbms_workload_repository.ash_global_report_text(584958394, Null, SYSDATE-1/24, ...
0
votes
1answer
30 views

RMAN Backups - Can more than one media management software solution be used?

Does anyone know if it's possible for two different backup utilities to be used to backup the same Oracle database? Both utilities would use RMAN. So, for example, take an Oracle 11g standby DB with a ...
0
votes
1answer
14 views

Java application not using Transparent Application failover in Oracle database

I have a customer that have a RAC environment (2 nodes, database version is 11gR2). Clusterware version: [grid@server2 ~]$ crsctl query crs releaseversion Oracle High Availability Services release ...
-1
votes
1answer
43 views

Oracle index analyze stats - managed by whom?

Some questions about managing indexes. We saw in some cases where indexes weren't analyzed in weeks, even though data was inserted and queried from them - using conditions that use these indexes. The ...
0
votes
1answer
44 views

why do i have that unnatural process on my server

i have an abnormal process on my RedHat server i tried to kill it but it appears again and because of that process i can't start my fusion middleware any ideas please when I execute the command TOP ...
0
votes
0answers
14 views

Oracle(12+) + Kerberos = Protocol Violation

we have an various oracle database installations and a few Kerberos KDC servers application uses JDBC driver latest 8 version and it works perfect with 11.2 version but when I try to connect to a bit ...
1
vote
1answer
30 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 ...
0
votes
1answer
27 views

How to install Oracle's sqlplus on a Mac? [closed]

I need steps how to install Oracle's sqlplus on a Mac.
0
votes
1answer
37 views

Preserve capitalization of column names/keys returned by SYS_REFCURSOR in Oracle

I am using a SYS_REFCURSOR to return JSON data to an ORDS endpoint. I need the case of the returned column names/JSON keys to be preserved for use in my node application. I have tried the following: ...
1
vote
0answers
23 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, ...
0
votes
1answer
31 views

Is there a better way of displaying 'Count' of records beside other columns in a select query?

I have a table with below structure : Test1(c_num number ,c_first_name varchar2(50), c_last_name varchar2(50)) 1)There is a normal index on c_num column. 2)The table has nearly 5 million records. I ...
0
votes
1answer
13 views

oracle XE 18c inmemory settings

I try to this in oracle XE 18c. I cant't alter inmemory_size property but can alter sga_target. Who relieve me? SQL> alter system set inmemory_size=200M; alter system set inmemory_size=200M * ERROR ...
0
votes
2answers
30 views

Oracle 12c - Insufficient Privileges When Trying To Create A Trigger With SYS User

I want to create a trigger for CRE schema. I'm trying to create this trigger with SYS user but I have insufficient privileges error. My trigger: CREATE OR REPLACE TRIGGER CRE.TRIGGER_NAME AFTER LOGON ...
0
votes
0answers
18 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 ...
0
votes
1answer
31 views

How to use 'Bind Variable' with 'With clause' in a Dynamic query using PLSQL

I have three tables with these structures: 1) z_test_a(c_num number , <other columns>) 2) z_test_b(c_num number , Amount number , <other columns>) 3) z_test_b(c_num number , Amount ...
3
votes
2answers
59 views

How to create index to improve performance of an aggregate function that creates a table in oracle

I am creating an Oracle ORDS API using APEX_JSON. I recently started using bind variables instead of string concatenation using ||. I am trying to use an in clause in my where condition. The problems ...
0
votes
1answer
17 views

Oracle DB not generating AWR

Sysaux tablespace is almost full . Could this be the reason AWR snapshot is not generated ? Although I do have the AutoExtend ON for SYSAUX tablespace.
0
votes
0answers
39 views

Error When Altering Table - invalid ALTER TABLE option

CREATE TABLE STUDENT (STUDENT_ID NUMBER (10), Matriculation_Date DATE, Enrollment_Status VARCHAR (11), Enrollment_Effective_Date DATE, First_Name VARCHAR (20), Last_Name VARCHAR (20), ...
0
votes
1answer
25 views

Oracle - Should processes limit be lower than sessions parameter

SQL> select * from v$resource_limit; RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE ------------- ------------------- --------------- ------------------ ------...
2
votes
3answers
56 views

How to rollback database change in production after few hours or days

We are using Oracle 12c in production. Lets say there was release that went to production on Sunday and then some hours or some days later(e.g. Tuesday) we realized that we need to rollback the ...
0
votes
1answer
22 views

Oracle live data updates for frequently updated table: poll or CQN?

My team is looking at getting live updates from our Oracle database from a frequently updated table. I have discovered CQN and configured a test environment to use UTL_HTTP to POST to a webhook when ...
0
votes
1answer
17 views

Oracle auditing: Is it possible to log when a permission is being used?

Does Oracle offer a way to log instances where a given permission is evaluated? Suppose I GRANT SELECT ANY DICTIONARY or something similar to a role, I am looking for a way to log every instance where ...
0
votes
2answers
29 views

How to create a same user in different PDB while it exists in other PDBs?

I have a list of 100 PDBs in the CDB, say the account_user exists in 50 PDBs and to create the same account_user in other 50 PDBs instead of logging into each PDB and creating user, is there a way to ...
0
votes
0answers
52 views

https://localhost.com:5500/em not working [closed]

I installed Oracle 19c correctly. But when I tried to access it by "https://localhost.com:5500/em", it's not working. I followed this thread but didn't work for me. 5500 port is also open. ...
1
vote
1answer
42 views

Trouble connecting to Oracle database with sqlplus and OS authentication

I am a read-only user to an oracle database, and the DBA gave me two accounts, one with a specific user name and password, and another with OS authentication. The OS authentication is supposed to let ...
0
votes
1answer
37 views

Getting generic Oracle error message 'missing right parenthesis'

CREATE TABLE IDN_ORG ( ID VARCHAR2(255) NOT NULL, TENANT_ID INTEGER NOT NULL, NAME VARCHAR2(255) NOT NULL, CREATED_TIME TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, LAST_MODIFIED TIMESTAMP ...
-2
votes
1answer
25 views

Oracle View inside an SQL Server Instance?

I have an Oracle View (in an Oracle database). I am moving to a new project that uses SQL Server but this view contains data that I need access to. Is there a way (other than dumping data then copying ...
0
votes
2answers
88 views

How to use 'Bind Variables' in a 'Dynamic Query ' when the exact number of variables are not known

I have a procedure in which I'm using Dynamic SQL(variable actual_query) and I'm generating this query based on the input parameter i_tables which is a concatenation of the name of some tables. It has ...
0
votes
1answer
40 views

How to display the exact query in the output section of a stored procedure when using 'Dynamic SQL' and 'Bind variables' in Oracle

I have a Procedure as you can see below. In this procedure I have a dynamic querywhich is qry variable and I'm using Bind variable in order to eliminate the risk of injection and improve performance: ...
0
votes
1answer
20 views

How to estimate needed undo retention for a operation?

Recently I needed to create a new table with CTAS. But after 4 hours of work I've received the erro snapshot too old How can I estimate the needed undo retention for a operation?
2
votes
1answer
77 views

Query customers attributes

I need to create a system where the user creates dynamic filters based on our customer's attributes. There are more or less 30 possible filters and 30 millions of customers, but the number of customer ...
0
votes
1answer
19 views

Oracle 11gR2 - How To Audit SYS.USER$ Table

I have a Oracle 11gR2 database and I want to audit all select operations on SYS.USER$ table for which users select on this table. When I try this command (I'm trying to run this command with SYS user):...
1
vote
2answers
39 views

Can an Oracle 19c database dblink to an Oracle 10.2.3 database?

I have an Oracle 12.1.0.2 database that dblinks to an Oracle 10.2.0.3.0 database. I am upgrading the Oracle 12.1.0.2 database to 19c (12.2.0.3). Will my dblinks to the Oracle 10.2.0.3.0 database ...
1
vote
1answer
27 views

How to use GROUP BY on a CLOB Column

i'm trying to use this QUERY which contains a Clob Column (flow.IDFONCTIONNEL) SELECT flow.flowid, min(flow.CONTEXTTIMESTAMP) contextTime, flow.STATUT, flow.IDFONCTIONNEL, flow.ETAT FROM Flux ...
3
votes
2answers
123 views

Get if field has max value and display value

I need to display Y or N when displaying rows in a report based on the max value for them on their version. If they have multiple versions all of them will display 'N' but the max (last version) will ...
-1
votes
1answer
34 views

Oracle Select Query based on a column value

I have two tables and wanted to conditionally query one of the tables. For example below are the two tables with few matching columns in two tables Table A(SNO, Number,Name...) Table B ( SNO, Number,...
0
votes
2answers
34 views

Can't find missing packages Oracle Linux 8

super newbie here. Trying to learn DBA stuff. I've been trying to install oracle database 18c on Oracle Linux 8 but there are two missing packages that are just not being found. I need these to ...
2
votes
1answer
34 views

How to figure out the latest version of a table in the 'recyclebin' section of PL-SQL developer

There are three tables with the same name Pantea in my recyclebin section of pl-sql developer and I don't know how to find the one that had been dropped the last (I mean the last version of the table)...
0
votes
2answers
51 views

Multiple group by with inner query in Oracle

I have a table Record with three columns: p_id, score, city. P_id score city 12 20 Mumbai 12 80 Delhi 12 50 Pune 13 20 Mumbai ...
2
votes
1answer
46 views

Raise application error in a stored procedure when inputs contain keywords like 'delete' , 'insert','update'

I have a Stored Procedure which gets 6 input queries and the inputs are the same as where clause of a query. For instance where x=1 and z=5 and e=4. The Application makes these input strings and pass ...
1
vote
0answers
47 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 ...
0
votes
1answer
37 views

Retreive the list of Up/Down status of Oracle database using Shell Script

I am trying to create a shell script for retrieving the list of Oracle database with status UP/DOWN.
-1
votes
1answer
26 views

Does SQL Server perform instance recovery after clean shutdown compared to Oracle Database?

If Oracle detects that an instance recovery is needed (like issuing shutdown abort command or crash happens), it will initialize recovery process. What about SQL Server? Does it behave in the same way?...
0
votes
0answers
31 views

Is safe to make backups of vm that contain Oracle databases using veeam backup or another similar tool?

I would like to know if it is advisable or safe to make backups of vm that contain Oracle databases using veeam backup or another similar tool, my doubt is caused because I have several vm with Oracle ...
0
votes
0answers
23 views

How to import Dump of 12.2 to 12.1.0.2.0 (Higher to lower version)? [duplicate]

I took a backup of one database using expdp utility. Unfortunately, this database had been corrupted. I have another oracle server installed on another machine. I want to import available dump to this ...
1
vote
2answers
52 views

Case when to sum fields for different condition retrieves both results [closed]

I'm trying to sum fields based on condition but the query results display both results for both conditions. This is the query I'm using: select distinct project_id, version, phase, fund_v, ...

1
2 3 4 5
136