3,993 questions
-3
votes
0
answers
37
views
oracle copy rows from multiple tables according to relationship
what is the best practice to copy rows from multiple tables according to relationship into one table or to same multiple table in different schema at one transaction so if any error happens the whole ...
- 2,618
0
votes
0
answers
33
views
Tracing configuration in Oracle Enterprise Manager
I'm optimizing a form in Oracle Forms 12c, and to identify the points where it takes the longest, I've enabled traces for events:
65 (Procedure (Start & End). - duration
66 (Trigger (Start & ...
-1
votes
1
answer
49
views
Replicate data to another DB server in Oracle [closed]
We have an Oracle DB running for a production environment. To not effect online processes we keep the data limited in this. Like one year. There is a job running everyday to delete older entries.
We ...
- 29
0
votes
0
answers
37
views
How to load data which is dmp file to oracle db
I have an Oracle database running on a remote server, but I do not have access to the server itself. However, I have a user account having dba privilage that allows me to connect to the database using ...
- 3
0
votes
2
answers
75
views
Issue with INSERT ALL SQL statement Oracle
I got an issue with INSERT ALL statement for the below table and this table has a Before Insert trigger which automatically populates the date when the ID_NO column is populated.
CREATE TABLE TestA
(
...
0
votes
0
answers
75
views
StoredProcedureQuery does not end
We are trying to call a PL/SQL Procedure that runs in a Oracle Database. The complete PL/SQL procedure runs for 10-12 minutes.
With SpringBoot 3.x with Java 21, we use Hibernate to call this Stored ...
0
votes
0
answers
27
views
ODI studio command line interface to import ODI xml scenario file and execute. How to do it?
I have ODI Studio installed and the ODI agent configured. We have a test environment where an ODI XML scenario has been exported. Now, we need to import and execute the same exported XML scenario in ...
- 11
1
vote
1
answer
59
views
Why is not the PL/SQL package state not reset?
I have encountered a weird behavior with initialization state of a package when ORA is thrown. Here is my example that I run on Oracle 12c:
create or replace package pkg is
v_num number := pkg_two....
- 33
2
votes
1
answer
130
views
How to prevent temporary table operations from generating archive logs in Oracle Database?
In my application, we dynamically create tables to store session-specific information. These tables are created at the beginning of an active session and dropped once the session is closed. Recently, ...
- 397
0
votes
1
answer
49
views
How to change Oracle's Enterprise manager 12c runtime properties from a webservice call?
I work with Oracle SOA Suite (Oracle fusion middleware 12c and 11g), combined with weblogic 12c, Azure pipelines, git repository, and SOAtest from parasoft as testtool.
I want to be able to change ...
- 195
0
votes
1
answer
118
views
Grant rights to create tables in a particular Oracle schema
What is the correct procedure for allowing team members to develop applications and create tables in only a specific schema?
I am running Oracle 12C. If I create a schema - say MYAPP1 - how should I ...
- 686
1
vote
3
answers
74
views
SQL query not fetching correct number of records
I have this SQL query. When I specify the date and time explicitly, it shows the correct number of rows:
select *
from annual_report_order
where report_order_date >= '29-OCT-2024 00:00:00.000'
...
- 39
-3
votes
2
answers
52
views
Adjust the date as working date | Oracle |
I was reviewing several articles on Stack Overflow and came across a query that worked as expected. However, I need to make some modifications to tailor it to my specific requirements.
I need to ...
2
votes
2
answers
149
views
oci_connect(): OCIEnvNlsCreate() failed in RHEL 8 with HTTPD
I need your help to connect to Oracle in PHP8 on my Red Hat 8.9 server.
OCI8 is enabled and the HTTPD web server is installed. This is my code:
<?php
// Enable error reporting in PHP
...
- 868
0
votes
1
answer
34
views
Get 12 month running total for subgroups in Oracle
I'm trying to get a running 12 month total for data, but changing when values in my fields change. I've made a simpler sql fiddle, for a 3 month running total, for one value in the table. I'm stuck ...
- 7,976