Questions

Good Morning,In the last year, I've started to support Mongo databases. Mongo stores data in BSON which is the binary form of JSON. JSON is just the field name followed by a value. This doesn't seem so different from Oracle since Oracle also its data in a s...

We have two tables, ITEM table has more than 150 million records and ITEM_EVENT table has more than 400 millions. Because of the growing nature of the data, we want to perform periodic cleanup of the tables. Could not find a performant way to achieve the goal,...

Hi TOM:I have to copy an AS400 table, for that i have a DBLINK that connects the as400 database to my Oracle 11gSince it has several millions records, i tried with a bulk collect:<code>CREATE TABLE AS400_VPRA_ABONO ("ABON_NUM_CCTE" NUMBER(9,0) NOT NULL ENABL...

Hi TOM,Not long ago it was easy to determine if your DB is on premise or on cloud: their banners (from v$VERSION) were different.Now Entreprise and Standard original editions can be on premise or on cloud so we can no more determine in which environment we are...

Hi there, masters.I'm facing a rather weird situation regading the TSTZ configuration. A full detailed description of my initial problem is here in this post I made some months ago: https://community.oracle.com/tech/developers/discussion/4490678/ora-39405-sta...

Dear Tom,I'm wondering about how a 'cancel' in Oracle works.For example, I have a long running query and I define a timeout on application level.Once the timeout is reached, the application sends a 'cancel'.What i observed is, that the cancel does not seem to ...

Greetings,I have created a map in Oracle APEX where the user can click and get the lat and long and drop a pin there. Now, I want to find which congressional district the pin was dropped in. I have a table with all congressional districts, but that is geojson ...

one of our DBs experienced a performance slow problem after a network issue, according to AWR report, the 2 bottlenecks are "disk file operations i/o" and "session login/logoff", since we have db audit turned on and it writes audit info to reboot os file throu...

connect system password : password. i got following errorsORA-01034: ORACLE NOT AVAILABLEORA-27101: shared memory realm does not exist...

From the following table , I want to build a query using analytical functions to retrieve the rows where there is a common document type for a Customer ID but not the mix. The output should be only ROW_NO 3,4,5 & 9,10CREATE TABLE TAB_DOC_TYPES(ROW_NO NUMBER,CI...

I need function which convert numeric to alphabet like when I input 1 then it will return 'A', when i input 2 then it will return 'B' please help me on this....

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) ...

Let's say we have a table of documents with key of doc_id. This table contains millions of documents(rows). There is also a table that assigns one or more industry codes to each doc:create table doc_ind( doc_id integer, ind_code varchar2(10))This ta...

Some Days before I have Install Oracle Database New version 12.1.0.2 with no error or warnings.Created 2 pluggable databases in the DB container. <code>SELECT name, open_mode from v$pdbs; NAME OPEN_MODE------------------------------ -...

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...

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 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 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 ...

Hello,We are start using EBR last year and sometimes we find some surprising behavior.Today I found that comments of editionable view are lost after view compile in a new edition. :-(Testcase:<code>alter session set edition=ORA$BASE;create user ebr_t1 default ...