Skip to main content

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
1 answer
19 views

Oracle - manual replication and force logging

When we configure Data Guard, we enable force logging. If we set up manual replication (via rsync and cataloging the archives at the destination + database recovery), do we need to enable force ...
Astora's user avatar
  • 793
0 votes
0 answers
31 views

Is there a way to know until what time a point-in-time recovery of an Oracle database was performed?

Is there a way to know until what time a point-in-time recovery of an Oracle database was performed? I only found references to the columns RESETLOGS_CHANGE# and RESETLOGS_TIME in V$DATABASE, but ...
Astora's user avatar
  • 793
0 votes
0 answers
17 views

oracle 19c user getting EXPIRED & LOCKED within several minutes when all password related settings in its profile are set to unlimited

I cannot understand why the account in Oracle 19c NON-CDB database getting locked few minutes later after creation. Audit trail is not configured. I'm running the database in container, it's Oracle ...
bezraznizi's user avatar
-1 votes
1 answer
27 views

Select hierarchical rows in proper order

How do I fix this query in Oracle? SELECT t.id, t.code, t.text FROM our_table t WHERE EXISTS ( SELECT 1 FROM our_table root WHERE root.id = t.root_id AND root.code IN ('1', '2') ) ...
demavi's user avatar
  • 99
0 votes
1 answer
24 views

Oracle - Completly audit of normal users and DBA's

Which is the option to enable user audit and DBA actions? I mean, let's say we audit a table called salary. No normal user can update the table without being audited. But a DBA (which has full access ...
Astora's user avatar
  • 793
0 votes
0 answers
16 views

Select, Filter and Sort ist not working with Oracle SQL Developer

I am using SAP ADBC to UPDATE some Oracle database entries. It's working and the data appearance in the SQL Developer between "normal" and UPDATED entries look same. But when I use a, SELECT ...
Fuat's user avatar
  • 1
0 votes
0 answers
15 views

Rotate encryption key for asm tde wallet oracle 19c

I have 1 database that has the tde encryption wallet located in ASM rather than o/s I now need to rotate the encryption key. I normally do this by changing the key ob one node then copying to the ...
anne scott's user avatar
0 votes
1 answer
20 views

Oracle 19 recover table with remap and constraints issue

I have a Oracle 19 DB that I am testing table restores from RMAN backups. I am using this code. recover table "HR".REGIONS OF PLUGGABLE DATABASE 'pdb' until ...
cptkirkh's user avatar
0 votes
0 answers
43 views

ORA-65139: Mismatch Between XML Metadata File And Data File

I have two systems - SYS1, SYS2(stand alone). On both is running an oracle 19c database. I want to create a plugable database from SYS1 and want to plug in the SYS2 database. I created the pluggable ...
ca2510fl's user avatar
0 votes
2 answers
55 views

How to Restore RMAN Backup at Specific Date

I have daily backups of my test system which is taken daily full backups and also hourly arch backups. I need to restore one of these backups to another linux server. I've completed all steps until ...
postgresnewbie's user avatar
2 votes
2 answers
70 views

RMAN - keep until and control_file_record_keep_time

Should I adjust control_file_record_keep_time to match the KEEP UNTIL value in my RMAN script? Here's my monthly backup script: RUN { BACKUP AS COMPRESSED BACKUPSET FULL FORMAT 'FULL_MONTHLY_%...
Astora's user avatar
  • 793
0 votes
0 answers
26 views

What are the implications of PLSQL_OPTIMIZE_LEVEL=2 and PLSQL_DEBUG=TRUE?

I have an Oracle database (19c EE) where several users develop PL/SQL Code. When I query the view USER_PLSQL_OBJECT_SETTINGS it shows me 700 entries with PLSQL_OPTIMIZE_LEVEL=2 and PLSQL_DEBUG=TRUE. I ...
WayneNani's user avatar
  • 113
0 votes
1 answer
46 views

Oracle database backup recovery

Just startet to study Oracle, i need to restore database backup. Log file said it was made in Oracle Database 10g Enterprise. I have Oracle XE 18, is it even possible to make it for XE version usind ...
Артем Павлов's user avatar
2 votes
1 answer
36 views

Oracle optimizer does not use column group information from multiple tables and misses correlation

I have a problem where the execution of a query is too slow in oracle 12c standard edition. I figured out, the optimizer estimates wrong cardinalities because it misses the correlation between two ...
egen's user avatar
  • 21
3 votes
0 answers
24 views

How to check if Oracle Database is using EBR ( EDITION-BASED REDEFINITION) or not

As per Oracle's documentation, since version 11g, Edition Based Redefinition (EBR) is initialized with a default edition named ORA$BASE. Any future EBRs are children of this so-called "edition&...
benbart's user avatar
  • 31
0 votes
1 answer
59 views

How to Make Queries on a DATETIME Column Efficient If My Primary Query Pattern is an Hour?

Context Here is the DDL that I am intending to use to define the table for a logistics/delivery company. CREATE TABLE scraping_details ( id INT IDENTITY(1,1) PRIMARY KEY, -- Identity insert and ...
Della's user avatar
  • 73
0 votes
1 answer
36 views

Is it any performance downgrade when query separate db (by db link) on same physical server

I have simple question but i could find any information about it. I also run some tests but didn't get any results that i measurable. Let say i have same structure with same data on my db and second ...
cargt3's user avatar
  • 1
-1 votes
0 answers
18 views

The insertion of data by Oracle fails and no error message is reported in the console

There are two database inserts in one process,The first insertion sometimes fails and no error message is reported in the console(It succeeded in the morning, partially failed in the evening, and ...
Evelyn's user avatar
  • 1
0 votes
0 answers
46 views

Calling stored procedures multiple times in the same transaction

I have a PLSQL Package with several stored procedures inside. This package is used to create specific reports. I call the procedures like that : package.init(parameter1 => 'Blablabla'); package....
Luke's user avatar
  • 1
0 votes
0 answers
28 views

How to Recreate Redo Log Files During Database Restore?

is it possible to recreate the redo log files during the database restore? I used the following command: run{ ALLOCATE CHANNEL c1 DEVICE TYPE disk; set newname for database to '+DATA'; RESTORE ...
Astora's user avatar
  • 793
0 votes
1 answer
28 views

Listing all declared advanced query rewrites in Oracle

The DBMS_ADVANCED_REWRITE documentation page for Oracle explains how to declare query rewrites and drop them, but doesn't explain how you can list all declared rewrites in the database. Is it possible ...
Jaka's user avatar
  • 103
0 votes
0 answers
66 views

Oracle 19C: Unable to process database creation using DBCA (Database Configuration Assistant)

After downloading Oracle 19c, I ran terminal as administrator and followed the instructions based on the official documentation (https://docs.oracle.com/en/database/oracle/oracle-database/tutorial-...
user avatar
0 votes
0 answers
54 views

ORA-03113 error running Oracle container in Docker

I am on an Mac M1 machine. I am trying to spin up a docker container with the command docker run -it -e ORACLE_PASSWORD=<pwd> gvenzl/oracle-free:23.3-slim-faststart The image is pulled ...
boston-hacker's user avatar
0 votes
1 answer
17 views

sqlplus column header misaligned

In wide sqlplus reports, column headers get misaligned from the data The code that led to this output was: set linesize 32767 set trimspool on col z format a1 alter session set nls_date_format='...
Brian Fitzgerald's user avatar
0 votes
1 answer
30 views

Oracle temporary tablespace performance

I'm looking for ways to improve my database performance for heavy analytical queries and found that my temp tablespace has 1M extents (default for uniform tablespace). With my usual temp tablespace ...
Andy DB Analyst's user avatar
0 votes
0 answers
30 views

How to Determine the Low High Water Mark (LHWM) in Oracle DB?

How could one determine the position of the Low High Water Mark (LHWM) for a non-partitioned heap table segment in Oracle? I am concerned, that if we only do direct path inserts and never update, ...
Alex Bartsmon's user avatar
1 vote
1 answer
54 views

ORACLE: RDS On AWS

This may be a lack of understanding as I am a MSSQL DBA more than Oracle. We are running Oracle on RDS in Amazon. Engine Version 19.0.0.0.ru-2020-10.rur-2020-10.r1 I dropped an old _backup table but ...
Stockburn's user avatar
  • 431
1 vote
0 answers
35 views

Object visualization problem with owner DBA

I'm having a problem viewing other owners' objects, even though I'm logged in as a user with DBA permissions PL/SQL does not display the view/edit spec & body option For testing purposes, I ...
Igor Oliveira's user avatar
0 votes
1 answer
21 views

Issue with DBSAT Tool Stuck at "Setup Complete" Stage

We want to perform a security assessment on our database using the DBSAT tool. However, we are facing an issue. When I run the DBSAT, it gets stuck at the "Setup complete" stage and does not ...
Mahammadali Aghabayli's user avatar
0 votes
0 answers
41 views

How to import Oracle unified audit spillover files generated by Data Guard physical standby database without switching over?

I know that I can use the DBMS_AUDIT_MGMT.LOAD_UNIFIED_AUDIT_FILES procedure to load the unified audit spillover files (*.bin) into the internal unified audit tables in an Oracle 19c database. But, ...
cdub's user avatar
  • 101
0 votes
1 answer
60 views

Database systems - data type alignment padding and record size (C/C++ related)

In PostgreSQL there is alignment padding of various datatypes which can increase (or decrease) the size of records (as stored on disk) in varying ways (see these links, 1, 2, 3): I searched for "...
Vérace's user avatar
  • 30.2k
0 votes
0 answers
37 views

PDB restoration on other server

I want to restore only 1 pdb to another server, how can I do that? the rman backup which i have taken from another server has a different control file, and the server on which i am restoring the pdb ...
datascinalyst's user avatar
0 votes
0 answers
33 views

Audit attempts to access the Database, only failed for some users and all attempts for the rest

I am needing help to be able to configure an audit mechanism that allows me to record in the audit_trail the login (or create session) attempts in my databases, the problem comes when I need to record ...
miguel ramires's user avatar
0 votes
0 answers
55 views

Oracle Data Pump Export (expdp) how to exit if invalid credentials and not wait to provide valid one?

Execution: Export: Release 19.0.0.0.0 - Production on Thu May 9 07:58:59 2024 Version 19.20.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. UDE-01017: operation ...
Jakub P's user avatar
  • 157
1 vote
2 answers
73 views

Oracle SQL query slow even with indexes

I have an Oracle 19c database (19.0.0.0.0), and two tables with lots of columns, I'll mention only the relevant ones: table1: createtime date contact_key char(96 byte) table2: contact_key char(96 ...
Gábor Major's user avatar
0 votes
1 answer
48 views

SQL Developer MySQL to Oracle migration auto_increment and identity columns

Ok, So in learning about migrating from MySQL 8 to Oracle 19 I have run into an issue. My tables in MySQL have auto_increment on the primary key. When I walk through the migration and get my master....
cptkirkh's user avatar
0 votes
1 answer
48 views

join two table by closest date

I have 2 tables apply_record log_record How can I left join apply_record to log_record on the right closest date. for example final
陳品汶's user avatar
0 votes
2 answers
39 views

Gathering aggregate sum of rows, group by column in second table [closed]

Having trouble with a join and grouping values. Historically I have been able to pull sums of job sizes by client_host_name - using one table. Now we have a new table that adds a new value '...
Derek's user avatar
  • 3
0 votes
2 answers
39 views

Does Oracle database server stored runtime dynamic SQL?

I have a plsql below that executes dynamic sql. DECLARE sql_stmt VARCHAR2(200); BEGIN sql_stmt := 'SELECT employee_name FROM employees WHERE employee_id = :1'; EXECUTE IMMEDIATE sql_stmt ...
Idonknow's user avatar
  • 101
0 votes
0 answers
47 views

Copying data from old column to new column with large amount of records

While updating/copying the data from old column to new column we are facing the issue with tablespaces in database. Records count: 158 million+ Using below query to update the records, UPDATE ...
Mujahid Boramani's user avatar
0 votes
0 answers
97 views

How to connect db link from oracle to maria db?

I would like to connect a db link from Oracle 11g built in a Linux environment to MariaDB(10), a package built in a Linux environment (Synology NAS). Please guide me. The IP and port of the two are ...
user avatar
0 votes
1 answer
141 views

ORA-28000 The account is locked for SYS on the physical standby

I changed the SYS password on the primary and copied orapwd into the standby as documented. This approach worked fine for multiple databases, but for one standby, ORA-28000 appeared after a few ...
Brian Fitzgerald's user avatar
0 votes
1 answer
57 views

PL/SQL dynamic Index loop based on list variable

Currently, I am indexing column by column with the following code snippet: DECLARE already_exists EXCEPTION; columns_indexed EXCEPTION; PRAGMA EXCEPTION_INIT ( already_exists, -955 ); ...
Matt Miles's user avatar
0 votes
1 answer
86 views

Oracle 11c REMAP_TABLESPACE

I have a question about how it would affect making a remap_tablespace, I intend to make a remap_schema and remap_tablespace at the same time when I make an impdp since I want to make a copy of a ...
fah81's user avatar
  • 13
0 votes
1 answer
111 views

Oracle partition strategy suggestions

I have a transaction table with 1 billion rows per month (Approx. 50 GB/month). I will have aggregation of transactions for a specific user_id and a date range. The aggregation can be like Aggregate ...
Moinulla Baig's user avatar
0 votes
1 answer
46 views

How to register static listener in listener_scan as well?

I have a listener called "monitoramento" which has three static listener. SID_LIST_MONITORAMENTO= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=BRXXX_MONITORAMENTO) (...
Astora's user avatar
  • 793
1 vote
0 answers
24 views

Composite key with a auto-incremented column

I'm using Oracle, but this may apply to other Relational DBs, as well. Suppose I have a table T with columns C1, C2, C3, C4. Note: C4 is numeric. Is it possible to make C2, C3, and C4 a composite key ...
SBel's user avatar
  • 111
0 votes
0 answers
47 views

See an arbitrary SQL statement in oracle enterprise manager

I like to see any sql statement in the Oracle Enterprise Manager (oem) Cloud Control 13c, e.g. in the active session history. A simple select is not shown in any view. After some research I found in ...
th0rn's user avatar
  • 1
0 votes
1 answer
57 views

Flashback Logs Not Deleted With PDB Drop

There is a known issue with Oracle where the flashback logs are not reclaimable when a PDB is dropped and a restore point exists in the PDB. I can see a restore point in x$kccrsp but no restore points ...
Jim D's user avatar
  • 560
0 votes
1 answer
24 views

Network utilization maxed out during backup. Is it bad in itself?

We have a cluster of two Oracle DBs. Monitoring software agent is installed on both of the machines and overnight, when backups are happening, we get warnings that network interface utilisation on the ...
Tony Sepia's user avatar

1
2 3 4 5
156