1. Staging Tables in Oracle 23ai
Dani Schnider begins this blog saying, “Browsing through the Oracle 23ai New Features Guide, I once again discovered a small, inconspicuous feature that I had previously overlooked: There is a new option to create stage tables. What is the advantage of this enhancement?”
2. Separating Schema Owners and Developers
Marco Pachaly-Mischke says, “In an Oracle Database there is no real difference between a schema and a database user. Once a user creates some objects, these objects will form the schema. The user, eg. the owner of the objects, can do anything to it’s own objects, there is no GRANT or REVOKE option for these objects. GRANTs are only needed, if other users should be able to work with these objects.
This implies, that in a multi-developer environment, all the developers use the one schema user to add and modify the data model. Beside that, it is difficult to find out, which developer did what to the data model.
Of course we could introduce dedicated user accounts for all the developers and grant all the object privileges to these users. But a developer would still be unable to add new objects to the schema. This would require the “CREATE ANY …” privileges for the object types the developer should be able to add. And granting ANY-privileges is not a good idea at all. So what to do?”
The blog goes through the Problem, Solution and Auditing before arriving at its Summary.
3. Oracle GoldenGate 23ai – Permissions, what to know!
This blog begins with, “One of the biggest issues with Oracle GoldenGate over the years has been the database permissions needed for the GoldenGate Admin to use the product. Over the years, many users, admins, and consultants have tried to write scripts that would alleviate this concern. Ultimately, some manager or DBA would say “screw it” and grant the SYSDBA role to the GoldenGate user just to ensure that everything worked as expected.”
Then it covers:
- Moving towards 23ai
- OGG_CAPTURE
- OGG_APPLY
- OGG_APPLY_PROCREP
- Summary
- Possible Workaround
4. Shell script to delete old archive logs in RAC databases
This blog starts with, “Today, I will be sharing one handy shell script that can be used to delete old archive logs. Considering the archive logs are already backed up and not required for any recovery purpose. In the following example i will be deleting archive that are 5 days old…”
5. Management Approvals with the Users Application Type (24.06 EDM New Feature!)
Kate Helmer starts this blog with:
“The 24.06 update had over 20 new updates in Oracle EDM, and today I’m highlighting one that I find to be a very useful enhancement and allows us to define our approvals in a new way.
For those not familiar, there originally were two approval policy settings, Parallel and Serial. In the past year, Oracle’s released two more: Ownership and Management Approvals.”
The blog then goes on to cover:
- Step 1: Configure Users Application Type & Setup Approval Hierarchy
- Step 2: Configuring the Management Approval Policy
- Step 3: Testing the Management Approval
6. Update APEX social login credentials from SYS
Ilmar Kerm says, “We are refreshing development databases from production using storage thin cloning. Everything works automatically and part of refresh procedure is also running some SQLPlus scripts, using OS authentication, as SYS.
One database also has APEX, that uses APEX Social Login feature to give users single sign-on for both APEX Builder and the end user application. You can read here how to set it up using Azure SSO. But since APEX is fully inside the database, this means that the production SSO credentials get copied over during database refresh.
I would like to have a SQL script that would run as part of the database refresh procedure, that would replace the APEX SSO credentials. And I’d like that script to run as SYS.”
Jonathan Lewis’ blog gives an example of the pattern of the query, with two execution plans.
8. The Oracle Database API for MongoDB in Oracle Database 23ai
Julian Dontcheff writes about why and where you might use the MongoDB API.
9. How to check if Multilingual Engine is available in APEX 24 and later
This is a short post describing how you can check if your APEX installation supports Multilingual Engine (MLE)/JavaScript.
10. Run Oracle Database 23ai Free on Mac computers with Apple silicon
The writer has previously shared how to run the Oracle Database 23c Free database on an X86 Mac using PodMan. You can find that blog post here.
He says, “But what about Oracle 23ai and the newer M1/M2/M3 ARM based Apple silicon Macs I hear you ask, so here you go.”