Questions

I encountered a problem related to forcing the refresh procedure on the materialized view in a combined manner: - refresh_method = 'F' - out_of_place = true<code>DBMS_MVIEW.REFRESH('FOO_MV', out_of_place => true, atomic_refresh => false, method => 'F');</code>...

Hi,<b>There are several examples of hierarchal queries using the employees-manager example. Recently i came across hierarchal scenario where the table was storing multiple hierarchies. example data:</b><code>CREATE TABLE example ( Title VARCHAR2(50), ID ...

We are writing to discuss an operational challenge that we are currently facing with the integration of Oracle Integration Cloud (OIC) and Oracle Autonomous Database within our organization. Our setup utilizes OIC as the primary integration layer, in conjuncti...

Hi,I want to create a stored procedure / function which will call shell script and shell script will have command to copy the file from particular location of DB server to another location of DB server.I tried using the scheduler job same is working fine but i...

Hi Tom ,Not sure about category of this question but will explain the same We had come across one issue ..In pre staging server environment sequence column is generating incremented value as per the last record updated in a table via procedure (which is what ...

Dear friends,I try to export csv from a patitoned table ( 300GB ) it takes 3 hours (only one table), using following code<code>set term offset feed offset colsep '|'set echo offset feedback offset linesize 1000set pagesize 0set trimspool onSET TERMOUT OFFspoo...

Hi,I have a use case in which I want the end user to upload files from UI and it will directly store into the application's static files section. Are there any APIs available?Thanks,Tushar...

Hi Connor/Chris,I am struggling to reason about the case attached in the liveSQL session.P1 spec ('get_field_value' just returns the value of 'field' from the record given)<code>CREATE OR REPLACE PACKAGE p1 AS field_default CONSTANT varchar2(4)...

I'm trying to use march_recognize() to find purchases made for each customer for 10+ consecutive days.A day being the next calendar date. For example, if customer 1 made 2 purchases on 10-MAY-2024 at 1300 hours and 1400 hours this would not be 2 consecutive da...

How can I convince my developers there is a better way to do this?SELECT MAX (weight) weight FROM client.pet_weight WHERE pet_id = :pet_id AND setup_date = (SELECT MAX (setup_date) ...

<code>CREATE TABLE dept (dept_id NUMBER, dept_name VARCHAR2(50 CHAR), emp_count NUMBER);CREATE TABLE emp (emp_id NUMBER, emp_name VARCHAR2(50 CHAR), dept_id NUMBER);CREATE VIEW vw_dept_empcountASSELECT d.dept_id, d.dept_name, d.emp_count AS d_emp...

I have a table like below.<code>create table t2 ( id varchar2(1),val number) ;insert into t2 values ('a',1);insert into t2 values ('a',2);insert into t2 values ('a',3);insert into t2 values ('a',4);insert into t2 values ('b',1);insert into t2 values ('b',2);in...

I have been wondering for a long time why a select like "SELECT COUNT(*) INTO l_count FROM foo WHERE c_now >= ts + 1" in the following example issues a PLW-07204 warning but for example "SELECT COUNT(*) INTO l_count FROM foo WHERE ts < c_now - 1" does not.<cod...

I have done a little searching, and not found anything that speaks to this, thought I would ask the experts:Recently I had to build an SQL script to be run in SQLPlus, and this script invoked another with the @ usage, and passed in a derived value as an argume...

We have many files available in our Linux mount point and wanted to load them into the table. The solution I'm seeking is to load all the files(with no-header, a different set of columns in each file, comma separated and new line char is available).<b>Sample f...

Hi - we are doing some data conversion of our database associated with a vendor product. This means migrating from one version of the vendor schema to another. so remapping the data. During a performance run, one of the SQLs was taking longer to run. So I ran ...

We requested oracle apex work space area 100MB?It exceeds the over 90% size? How to calculate Current file Utilization and current database size?Requested Size: 100(in MB)Current File Utilization: 6.49(in MB) What is this?Current Database Size: 91....

We are going to MOVE the TBS of AUD$ table in PROD. Purpose:AUD$ table is totally fragmented and the CLEANUP / PURGE runs very slow - even with max 1.000.000 batch size but as per test in our test environment we had some issues regarding using API (DBMS_AUDIT_...

According Metalink note 785347.1 it seems possible to have a dataguard with primary 11.2 and standby 12.2 or even later but it is really very condensed.Could you please just confirm that 11.2 -> 12.2 is really possible?If so, what about 11.2 -> 19.x ?Or 12.2 -...

It took me 25 years to get used to Oracle using 1-based indexing in pretty much all API's.How the rather new json_array_t data structure used a 0-based indexing and drives me crazy.Is there any reason behind this "strange anomaly" or did someone just want to d...