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.
7,826 questions
0
votes
1
answer
25
views
Oracle: Insufficent privileges when compiling a stored procedure as DBA role
I'm complining a stored procedure as user with DBA role. The stored procedure contains several "DELETE" statements. For each of them I'm getting:
PL/SQL: SQL Statement ignored
PL/SQL: ORA-...
- 221
0
votes
0
answers
19
views
Oracle: unclear context memory usage
How can Sys_Context ('UserEnv', 'Global_Context_Memory') return several million bytes for the current session while Select From V$Context returns no rows and also Select Sum (Length (Value)) From ...
- 76
0
votes
1
answer
26
views
Unable to connect to auxiliary database
I am trying to create a standby (WIEN), however I am not able to connect to the auxiliary, and I don't see the issue, the same setup has been used for the primary (GRAZ).
GRAZ:
[oracle@server-graz dbs]...
- 137
0
votes
0
answers
18
views
Question about referencing PF keys in OracleSQL
Since MANIFEST.ship_code originates in SHIP, would the foreign key for MANIFEST be referencing CABIN or SHIP? I'm confused because it functions as a primary key for CABIN as well.
I think
ADD ...
0
votes
0
answers
34
views
Cannot connect to Oracle adb-free container from python
I am running ADB in podman locally on my MacOS.
I can connect using SQLcl and sqlplus.
Now I am trying to connect to my container ADB using python
I can connect using the oracledb library thick ...
- 747
1
vote
1
answer
84
views
Is it safe to add a datafile to a tablespace while Oracle Database is running in production?
I have an Oracle Database running in a production environment, and it’s currently under load. I need to add a new datafile to an existing tablespace. Is it safe to do this operation while the database ...
- 13
0
votes
1
answer
72
views
ODI-26211 "Mapping name is not unique" error — even with fresh repository and no agent
I'm working with Oracle Data Integrator 12.2.1.4.0, and I'm encountering a persistent repository-related issue.
❗ Problem:
When I try to save changes to a mapping or generate a scenario, I receive the ...
0
votes
1
answer
87
views
Meaning of the precision and the scale, in an oracle's reference?
According to the About the Precision and Scale Properties, it says,
The Precision property of an object type specifies the total number of digits that can follow the decimal point for a numeric field:...
- 175
1
vote
1
answer
52
views
How to check maximum connections for a PDB
In Oracle, how can I check the maximum number of connections for a PDB?
I used:
SHOW parameter processes
But I'm not sure if it's the correct method.
- 163
0
votes
0
answers
49
views
Use of constants in CASE statements in PL/SQL
Can anyone explain why a utPLSQL unit test works when calling a stored procedure with the following code in:
RETURN CASE WHEN pi_is_scientific_notation = 'T' THEN v_display_format || 'EEEE' ELSE ...
- 1
1
vote
0
answers
44
views
Dynamic sampling works differently than documented
Dynamic sampling in Oracle versions 12c to 19 is documented as functioning the same if it is enabled via the init parameter or by hinting.
This does not seem to be true.
I have tested this in customer ...
- 11
-1
votes
1
answer
95
views
Oracle Violates Short-circuit in CASE Statement
Problem
I am well aware that SQL is a declarative language and does not enforce short-circuiting. Oracle, on the other hand, explicitly states that short-circuiting takes place for CASE statements.
I ...
- 3
1
vote
1
answer
72
views
Update multiple rows using select statement in Oracle
Im using this script for updating "gndt_customer_identification" table, value of V_iden_no coming from select statement.
How i can update multiple row when select return more then one value ...
- 21
0
votes
1
answer
116
views
srvctl relocate database timeout is not honored
We are testing connection behavior during manual relocation of RAC One Node database to achieve zero down-time relocation.
When shutting down with IMMEDIATE mode, connections close too fast without ...
- 101
0
votes
1
answer
63
views
Oracle Redo Log shipping from PRIMARY to PRIMARY
I am setting up online and archived redo shipping from a source database (PRIMARY) to destination database (PRIMARY). I cannot use a STANDBY database as destination as I have to setup real time ...
- 1
0
votes
2
answers
190
views
Cannot create MATERIALIZED VIEW with REFRESH ON COMMIT on query with multiple joins
In oracle, I have the following tables (ugly pseudo SQL below) :
CLIENT (CLIENT_ID NUMBER NOT NULL /*PK*/, GROUP_ID NUMBER NOT NULL)
GROUP (GROUP_ID NUMBER /*PK*/, GROUP_NAME VARCHAR2)
GROUP_DATA (...
- 121
1
vote
0
answers
88
views
Understanding of sqlplus STARTUP command syntax
On https://docs.oracle.com/en/database/oracle/oracle-database/19/sqpug/STARTUP.html, the document states that:
Startup command
...
where db options has the following syntax:
[FORCE] [RESTRICT] [...
- 2,126
0
votes
1
answer
47
views
Best way to store the latest child in a one-to-many relation?
Hi I have a table in Oracle APEX to store documents as well as their revisions:
CREATE TABLE M_DOCUMENTS
(
DOCUMENT_GUID VARCHAR2(38) DEFAULT ON NULL sys_guid(),
...
1
vote
0
answers
79
views
How to copy a large oracle table into another without tmp issues
I have a table "FOO". I have created a table "BAR" such as
CREATE TABLE BAR
PARTITION BY RANGE (BAR_ID)
INTERVAL (1)
(
PARTITION p0 VALUES LESS THAN (1)
)
AS
SELECT *
...
- 111
0
votes
0
answers
49
views
during import getting this error ORA-39183: internal error -19 ocurred during decompression
I have a dump file that was compressed with the compress parameter. however When I try to import it I am getting this error
ORA-39183: internal error -19 ocurred during decompression
should I add a ...
- 105
0
votes
1
answer
130
views
Dealing with Oracle over high-latency links
We have stand-by application-servers in multiple datacenters -- in case we must fail-over in a hurry -- and would like to make some use of them during the times of normalcy.
The Oracle databases are ...
- 166
0
votes
1
answer
270
views
Oracle scheduler, set repeat_interval to run job at exactly date and time?
I have question regarding Oracle scheduler.
How to set repeat_interval to run job on example, two times per month, at exact time?
On example:
5th in month, at 09:00 and
20th in month, at 14:00
Is it ...
Krešimir Margetić
0
votes
1
answer
389
views
Oracle alert.log "Thread 1 cannot allocate new log" on AWS RDS
I migrated from an on-premise Oracle XE to Amazon RDS. It's running on a T3.medium server with gp3 storage (200 GB/12000 IOPS).
Almost every fifth minute the alert.log says like this:
"Thread 1 ...
- 133
0
votes
0
answers
45
views
syncing data in Oracle 19c pluggable database with source database
I am creating an Oracle pluggable database 19c from another database. The source database is an operational database. After creating the pluggable database I have to run the commands to fix any ...
- 1
0
votes
1
answer
200
views
looking for the download of oracle grid infrastructure for 23
Where do i get the oracle grid softwware to run ASM on Oracle 23c. I have done if for 19 and other but can't findd the grid for 23ai.
