I wanted to add an append hint to some code but realised that there are known restrictions when either triggers or referential integrity are involved.
That does make sense as potentially rows would be inserted that either did not fire a trigger or broke RI constraints.
I decided to produce a test case to prove that the restrictions did work and were still in place.
Test append with trigger created
Thanks to the many attendees that came to my presentation "Oracle 12c Parallel Execution New Features" at the DOAG conference 2015.
SQL> select count(*) from all_objects_many_list;
SQL> select min(created) from all_objects_many_list;
I’m speaking at the Sydney leg on the OTN APAC tour on November 30th, 394 Lane Cove Rd, North Ryde
This is a great event with local and international speakers all giving their time and knowledge for free to help you with your Oracle technology.
If you’re in Sydney, then come along for some great education. Even if you cannot attend the conference, if you are in the area, come along and say Hi. Part of my job focus is helping developers succeed with Oracle, so we might be able to organise something in the future in terms of (free) education for your development teams.
This Log Buffer Editions picks few blog posts from Oracle, SQL Server and MySQL.
For one of my clients, I experienced several issues with applying PSU 126.96.36.199.5 with opatch 188.8.131.52.9.
There were some code changes in opatchauto, which are not yet production-ready. I am looking forward to seeing a new opatch release (maybe 184.108.40.206 or 11) which has these issues fixed.
What is the cause of the "ORA-27101 Shared Memory Realm does not exist"?
How do I resolve this?
If you are a regular user of LOB’s in the database, take care when you switch from 11g to 12c. Notice the subtle difference:
If you grant the DBA role to a user, Oracle also grants it the UNLIMITED TABLESPACE system privilege. If you then revoke the DBA role from this user, Oracle also revokes its UNLIMITED TABLESPACE system privilege.