Questions

I have an issue, where i am trying to upload data from my xml file into the table using oracle apex data parser api . I have 6 columns in xml file and in which 1 column is not having any data in any of the records . When i try to insert the data , instead of s...

Hi Team,I have a question about the background execution of dequeue procedures Oracle <b>Advanced Queuing</b>.We are using Oracle 19c & in our case, we are enqueuing AQ messages through DML triggers using dbms_aq.enqueue. Then we dequeue using dbms_aq.dequeue ...

Dear Tom, please help me with the below.Session 1:update table set field = 'A' where field2 = 'B';it is not committed/rollbackedSession 2:update table set field = 'C' where field2 = 'B';The session will be waiting for session 1 to get committed, but where the ...

Hello Tom,Please, I need a big help.I have a job scheduled in Enterprise Manager 12c. This job do a full export, but two days ago I started to get the error below:ERROR at line 1:ORA-31626: job does not existORA-06512: at "SYS.DBMS_SYS_ERROR", line 79ORA-06512...

I have a table that I converted to interval daily PARTITIONs.Ie<code>partition by range (date_col) interval (numtoyminterval(1, 'DAY')) (partition P_OLDDATA values less than (to_date('01-JAN-2021','DD-MON-YYYY')) ); </code>My issue is that there were some deve...

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

I need a example using DBMS_CRYPTO.SIGN.I'm need to sign a hash using RSA-SHA1 and I need to know if can i use DBMS_CRYPTO.SIGN?...

Dear Tom,I am temporarily supporting a RAC, ASM database on 19c. I have to create a new tablespace. For the existing tablespaces I see that datafile names look like +IPAG_DATA/t5cnp1db/datafile/avos_dat.362.1067066741 I understand that +IPAG_DATA is the asm di...

declare cursor cur_collection_detail is select rowid,'ABC' col4, 'ABC' col1, 'ABC2' action_id from TAB1 where COL1= 1286165;begin for dtl in cur_collection_detail loop dbms_output.put_line('Test inprogress..'); end loop;end;/ Error report -ORA-06502: P...

I want to change the column size of a column from varchar2(100) to varchar2(50) on a non-partitioned table with 1138 Million records, yes 1.1 Billion. This project is not using Partitioned tables, so can't change the table structure.Could you please let me kno...

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