(Zahid Anwar) Back in October 2017, I presented “RMAN Back to Basics” at the UKOUG Database SIG.
Tag: Oracle
Getting t1001 in interactive grid PK
(Mathias) Have you been plagued with the issue of getting values like t1001 show up in columns you marked as primary key in your interactive grid? In case you do not feel it is a good interface for your end users you may have found yourself spending quality time with Google looking for clues
During Extract Upgrade ‘extract not ready to be upgraded because recovery SCN’ returned
(Natik Ameen) During the upgrade of a Classical extract process to Integrated extract I get the “extract not ready to be upgraded because recovery SCN”. How do I work around this?
Using DbVisualizer to work with #Oracle, #PostgreSQL and #Exasol
(Uwe Hesse) As a Database Developer or Database Administrator, it becomes increasingly unlikely that you will work with only one platform.
How Select Statement Works
(Shesadev Biswal) When Oracle receives a sql query, it requires to run some pre-tasks before actually being able to really run the query.
Being generous to the optimizer
(Connor McDonald) In a perfect world, the optimizer would reach out from the server room, say to us: “Hey, lets grab a coffee and have a chat about that query of yours”.
Find files with errors
(Michael McLaughlin) My students wanted a quick solution on how to find the log files that contain errors.
Quicktip: Don’t grant access to a synonym
(Mathias) I’ve seen this in a few places lately. When I ask the database gays there about it, they think this DDL would never work or “it does nothing but does not return an error”.
REST Services now available for Oracle Autonomous Database
(Jeff Smith) The Autonomous Database is offered via two services in our Oracle Cloud, Autonomous Data Warehouse and Autonomous Transaction Processing.
Oracle Database Upgrade made easy with AutoUpgrade utility
(Syed Jaffar Hussain) Upgrading Oracle database is undoubtedly a daunting task which requires a careful study, planning and execution to prevent any potential post upgrade shortcomings.
