Questions

Tom,Could you please explain for which scenario I should consider non-prefix local index over prefix local index?Thank you very much for you time....

Hi Tom, We have 8i db one on the production server and another on the webserver (public access for online service). I have the same table created in both the database. I have a procedure to load the all the images form the file system about (1400) into t...

Tom,Is there a way I can find the first day and last day of a given quarter.In a given year, there are 4 quarters.If I select first quarter then I should be able to get the first day and last day of the first quarterexample: quarter = 1 and year is 2007. expec...

<code>Hi, Tom I wrote the following procedure, there are two PLACEHOLDERs which means two bind variablesand the two PLACEHOLERS have the same name, that is to say ,the name of PLACEHOLDERs are identical,they are both "MYTEST". In the procedure, I assign ...

Hi,I have gone through the TDE column and TDE tablespace encryption. Most cases TDE tablespace option is found to be better compared to TDE column option.Wanted to know what advantage TDE column encryption gives or rather the use cases for TDE column encryptio...

Hi, I have a sequence skip number problem.I have this sequence. The cache is 20 and noorder.<code>create sequence seq_serial_no minvalue 1 maxvalue 999 start with 2 increment by 1 cycle</code>The current situation that has arisen is:I have two servers A and B....

Hello, a few questions:1. All of the scripts I have written years ago use both address and hash_value to join v$session and v$sqlarea.What I don't quite understand is why it's not sufficient to just join on hash_value (or sql_id).Why was/is address also needed...

Hi,While listening through the video "Developer Coaching - Oracle Database 23ai - Zero Slides, Zero Marketing, 100% Live Demo" there mentioned that we can set the oracle wallet path to system: to access the windows level certificates, but when I tried the same...

Hope you're doing well.I'm reaching out to get your inputs on statistics gathering in our Oracle Autonomous Database (version 19c), which we use to support our integration workloads.We have a few very large tables (approximately 70 million records each) that s...

I want to upload multiple XLSX files, each containing multiple sheets. The data from each sheet should be inserted into a table with the same name as the sheet (the tables already exist) using Oracle APEX. Is this possible?...

Hi Chris/Connor. We have a production 12c Database (12.2.0.1) and have enabled a particular SQL Plan Baseline for a high-load query, but, for some reason, it's not being used. Baseline is ENABLED and FIXED, and REPRODUCED column reads YES, but I can't see a da...

Hi Tom,What I need to do is, to monitor a table for changes. For this a trigger needs to be setup. But my doubt is, if we create a trigger after insert or update of my table column on my table for each row, and the trigger does some time consuming task like DB...

I attended a Hotsos session by Toon Koppelaars yesterday morning on Semantic Query Optimization. Among other interesting topics, Toon lamented the lack of any DBMS implementing SQL "assertions". By which he meant a database-enforced constraint than encompass...

I have a requirement where I have to refresh tables from PROD to DEV. But refresh needs to be done in such a manner that partitioned table should be refreshed with its latest top 10 partitions and non partitioned table should be refreshed fullI am using DBPUMP...

Hi Tom,Oracle puts a TM lock on a table even if no rows are affected by a DML statement:TX_A>create table t (x int);Table created.-- just to show there are no locks on the table:TX_A>alter table t move;Table altered.-- in another session (marked as TX_B) we no...

Hi Tom,I am trying to view explain plan for a select statement in Livesql built on 19c oracle version.I am able to view the explan result using select * from table(dbms_xplan.display_cursor); but i see Error: cannot fetch last explain plan from PLAN_TABLE ...

how can i insert and read numeric value larger than 1000 digits into blob column in oracle...

El erro al crear un Interactive Grid en la versión Oracle APEX 24.2.0 en versiones anteriores funcionaba sin problemas ORA-01400: cannot insert NULL into ("APEX_240200"."WWV_FLOW_IG_REPORTS"."ID")...

We are currently in the process of upgrading our Oracle database servers from RHEL 7 to RHEL 8. We are considering two possible approaches:Migrating to a new server built with RHEL 8.Performing an in-place upgrade on the existing server.In both approaches, we ...

Hello!We encountered strange (and logically inconsistent) CBO behavior. To provide some context: we are working with an EAV (entity-attribute-value) schema, all objects are stored in a single table, let's call it "my_objects", another table, "object_ancestry",...