The ADRCI (Automatic Diagnostic Repository Command Interpreter) is a command-line tool that you use to manage Oracle Database diagnostic data. Below command will manually purgeRead More
Browsing Category : ORACLE
Oracle Database 20c New Features
New features of Oracle 20c: 1. Security – Force Upgraded Password File to be Case Sensitive – Connect to Multiple Databases with Different Certificates fromRead More
How to create user in Oracle Multitenant 12c without C## prefix
When I try to create a user without the c## prefix I get the ORA-65096 error: If you wish to create common userRead More
New dates for free certification exams on Oracle Cloud and Autonomous Database
New dates for free certification exams on Oracle Cloud and Autonomous Database. The deadline was extended until June 30 at 11:45 pm. MoreRead More
Run SQL Scripts in Multitenant environment with catcon.pl
Oracle has provided the “catcon.pl” perl script as a method to execute SQL scripts in a single container or all containers. In the example belowRead More
Renaming Pluggable Database
Objective Rename a pluggable database (PDB) from PDBWFM to PDBWFM01. $ sqlplus / as sysdba For rename operation a PDB must be in RESTRICTED mode:Read More