I got this question from one of my clients:How can I Audit Individual Functions/Procedures inside a PL/SQL Package?. Let us build a quick demo: This is just a sample package Let us try to enable this type of auditing using the following command:audit execute on scott.emp_pack.CreateEmp by access;I got the following error: As per Oracle … Continue reading Auditing Individual Functions/Procedures inside a PL/SQL Package
Oracle Database 21c Documentation
Oracle Database is the world's most popular database. Available on cloud and on-premise platforms, Oracle Database 19c is the most recent long term release, with an extended support window. Oracle Database 21c is the latest innovation release, initially available on Oracle cloud through Autonomous Database Free Tier and Database Cloud Service. For Oracle Database 21c documentation:https://docs.oracle.com/en/database/oracle/oracle-database/21/index.html For Oracle Database … Continue reading Oracle Database 21c Documentation
Introduction to Oracle RAC One Node
Oracle Virtual Machines for Sale !
Are you looking for a virtual machine to do some hands-on labs or practice something (i.e. for Educational purposes}? Do you have the time to build these virtual machines yourself? Below are some really nice Virtual Machines, that I invested allot of time to build on Oracle Virtual Box, and that I used them personally … Continue reading Oracle Virtual Machines for Sale !
Alter Pluggable Database Open – (ORA-00604/ORA-01405) After Apex Installation
While trying to open one pluggable database, I got the following errors: Background: While installing Apex 20.1 in one PDB, and while being very close to the installation completion, the session fully stucked.I restarted the database (the CDB), then I tried to open the PDB, but I got the above errors. While searching for this … Continue reading Alter Pluggable Database Open – (ORA-00604/ORA-01405) After Apex Installation
Oracle Database 20c is now Generally Available
Oracle Database 20c is now Generally Available on the cloud two days ago, 14-Feb-2020. Oracle 20c is next major database release. It includes many new fetaures espcially in the following areas: BlockchainMachine LearningSecurityJSONIn-Memory For a quick introduction to this new release:https://blogs.oracle.com/database/ga-of-oracle-database-20c-preview-release Also, for complete list of the new features, please refer to the:https://docs.oracle.com/en/database/oracle/oracle-database/20/newft/new-features.html Oracle Database … Continue reading Oracle Database 20c is now Generally Available
The Longest SQL Statement I have ever seen !
Below may be the longest SQL statement that I have ever seen. I don't know if it is written by one developer or group of developers and what is the logic behind it? I really don't like this style of writing sql statements. It is very difficult to be functionally understood. Also, it is very … Continue reading The Longest SQL Statement I have ever seen !
Oracle Database 19c (19.3) Installation on the Oracle Cloud Compute Instance.
As, I already have access to one Oracle Cloud Free Compute Instance (Oracle Linux), then I decided to install Oracle database 19c there and create a test database. This time, I'll use a different technique by installing Oracle Database rpm.Oracle delivered the oracle database software as rpm for Linux since Oracle 18c. Installation procedure is … Continue reading Oracle Database 19c (19.3) Installation on the Oracle Cloud Compute Instance.
Oracle Read Only Tables
Starting from Oracle 11gR1, oracle allows us to change a table to be a read-only table. Let us have a quick demo: I'm connecting as user HR ( to a 19c pluggable database). I have a small table "DEPT": So, now I'm going to change the table to be read only table: Now let us … Continue reading Oracle Read Only Tables
After Oracle Database Upgrade to 12.2, Database Express Did not work
I upgraded one database from 184.108.40.206 to 220.127.116.11 on one Solaris Sparc server. After that I configured the Enterprise Manager Database Express, but when I tried to access it, I got the following error: For more information about Oracle Enterprise Manager Database Express, please refer to my post:https://ahmedfattah.com/2018/10/14/oracle-enterprise-manager-database-express-12c-overview/ Environment: Oracle Solaris 11Oracle Restart 18.104.22.168Oracle Database … Continue reading After Oracle Database Upgrade to 12.2, Database Express Did not work