Questions

I ran into this problem with 1% of our records converting views from SQL Server to Oracle where my testing found different results when doing a compare during UAT. We have a system that needs to express time rounded to tenths of hours because of industry norms...

Hi Team,Can you please have a look at below:I tried copying table data from One DB to Other over DB link using DBMS_PARALLEL_EXECUTE.And it works as expected.Challenge I am facing here is:I have a table TB_TXN created on both Oracle DB.Now i want to copy speci...

Hi I have a rman full backup and I want to restore single table due to drop that table how can I do this.I can not create a clone due to space and resources issue..Thanks...

With row‑based replication (binlog_format = ROW), the function generates duplicate sequence values; in mixed mode (binlog_format = MIXED), no duplicates occur. Using AWS RDS 8.0.22CREATE DEFINER=abc@% FUNCTION nextval(seq_name varchar(100)) RETURNS bigintBEGIN...

Hello ,Hello, I'm having a rather strange problem:A single Windows user is unable to connect to a database hosted on the WINDOWSPROD server. The error is: ORA-12637: Unable to receive packet; in the alert.log:ORA-00609: Could not attach to incoming connectionO...

Dear Tom, I have a question. I have a profile say myprofile in dba_users view. I'm selecting how many users having this myprofileselect username from dba_users where profile='MYPROFILE';User1User2User3Now I want to check whether all this 3 users have Connect r...

Hello,In this query : <code>select id, to_char(txn_date, 'yyyymmdd'), count(*) from table1 where to_char(txn_date, 'yyyymmdd') > '20250101' group by id, to_char(txn_date, 'yyyymmdd') order by to_char(txn_date, 'yyyymmdd');</code>Will t...

I"m looking for guidelines on how to architect a new APEX solution for migrating legacyOracle reports to APEX.We have 67 seperate municipal government entitiesin 67 seperate Oracle instances. Some are 12c someare 19c. They are spread across 4 servers.Table str...

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