Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered Report

Chris SaxonQuestions about on commit refresh Fast MVs
Team:Here is my testcase used for the below demo. this was from 18c database.Questions:Q1 - why this error "ORA-10980" is reported in this trace file, what was the problem with my testcase ?Q2 - all three delete statements having the predicate like " where rid...
Chris SaxonIMPDP statement with multiple where and table clause
I have more than 20 tables to restore from exported dumpfile. so i have question how to import 20 tables into one impdp statement so my dba can save time. here i post two different impdp statement which contain different where statement and different tables to...
Chris SaxonHow to extract specific tags from a clob colum storing XML
I have a clob column that as different tags in it, like the example below, I am trying to get the comments tag of all the rows, one of them is returning null, I am assuming it is because it has the word "comments" more than once, this is the query I am using:...
Connor McDonaldPeriodically Test Recovery Procedures
Hello Team,I need to document our RMAN backup and restore best practices, and I'm struggling to answer the question:How often (months, years, etc.) should we test our restore procedures? (max time between restores, at least "RESTORE... VALIDATE")Thanks.Here an...
Connor McDonaldSQL Developer drops connection to Oracle Database 19c when trying to edit PL/SQL code
Dear Colleagues,I failed to find solution of my problem in the Internet and kindly ask for your assistance.Production database was migrated from Oracle 11 to Oracle 19. Middleware and the entire production system work fine. Allround Automations' PL/SQL Develop...