In some 10gr2 and 11gr2 Customer´s databases I need, inside sqlplus , print some data vertically, much like your PRINT_TABLE function, but my user is "read-only" , I´m not allowed to create nothing (ie, no stored PL/SQLs, no tables, nothing permanent) inside this databases, what...

I think there is a way to do this but I can't remember. We have 40 tables 500GB+ in size that we maintain between sites using fast refresh. It's a setup that's worked remarkably well for a long time which we don't want to change. We'll be rolling out a 3rd site soon. Smaller MVie...

Question We're evaluating different approaches to implement the Outbox Pattern in Oracle 19c for reliable event publishing in our microservices architecture, but we're concerned about the significant I/O overhead and performance implications. Could you provide guidance on the bes...

Hello. We just upgraded our main database from 12cR2 to 19c(exactly 19.25). Some of parameters are changed, including log_buffer. Previously we set log_buffer parameter to 20M, and also speicified in parameter file. After upgrade we removed because out consultant not recommanded ...

Hi Tom, I’m encountering an issue with my Oracle Database 23Free. It throws the ORA-12954 error: "The request exceeds the maximum allowed database size of 12 GB." After investigating the database files, I discovered that the SYSAUX tablespace is the main contributor to the size i...