Ask The Oracle Mentors

Recently Answered

	Questions 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...
	IMPDP 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...
	How 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:...
	Periodically 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...
	SQL 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...