sometimes you come into a situation where you have to drop all tables in a given schema. The easiest way is to delete the user and recreate him again but when lacking system privileges you will look for another way. I’ll find the following very handy and will delete all specified db objects…. BEGIN FOR…
Category: Oracle
Oracle 19c client installation
On of our customers has the requirement to migrate the actual OnPrem versionof SAP BO 4.2 SP5 into a Cloud infrastructure (Government BIT Cloud). Furthermore one of the requirements is implementing a new SAP BO 4.2 SP 8 and using Oracle Exdata 19c as repositories for SAP BO CMS and auditing. In the following will…