Free OCI Learnings/Certifications From Oracle along with Enroll steps for Certification Here is an exciting opportunity from Oracle to get certified at zero cost. Oracle has announced it will offer Oracle Cloud Infrastructure (OCI) training and OCI certification testing for free worldwide. The new program includes Oracle’s entire range of expert-created OCI learning curriculum for […]
Basics Of User Management in Oracle When a user logs on to the database, they connect to a user account by specifying an account name followed by an authentication method. Every user account must have a default tablespace. This is the tablespace where any schema objects created by the user will be stored. Permanent objects( […]
Step-by-Step Approach For Applying PSU Patch in Oracle 12c For Single-Instance In this article, we are going to see Oracle12c Step-by-Step Applying PSU Patch For Single-Instance database. List of the steps to follow during the activity : Check the current version of Opatch Tool Upgrade the Opatch utility if needed Take the backup of ORACLE_HOME Shutdown […]
Step by Step guide for Table Refresh using DataPump Utility Oracle Data Pump is a high-speed data movement utility provided by Oracle (10g onwards). It’s an extension to the old EXP and IMP utility with improved performance and enhanced security features. Requirement of Table refresh: Table refresh is a common task that is quite often […]
Step by Step guide for Full Database Refresh using DataPump Utility Oracle Data Pump is a high-speed data movement utility provided by Oracle (10g onwards). It’s an extension to the old EXP and IMP utility with improved performance and enhanced security features. Here we are performing a full database refresh activity using Datapump: PARAMETERS SOURCE […]
A Handy Guide for Basic Linux Commands Linux, an open-source Operating System is one of the most popular operating systems which takes inputs in the form of commands to direct a computer program to perform a specific task. To use this Operating System we need to get familiar with the commands to navigate between directories, […]
Target Blackouts in OEM13c using EMCTL In the literal sense, A blackout is a temporary condition that affects your memory. It’s characterized by a sense of lost time. In terms of the Oracle database, we can also perform a blackout in Oracle Enterprise Manager using EMCTL – Command Line utility. This is done to make the […]
ADD-DROP Redo Log Files In Oracle Database In the real world, we may encounter scenarios where we need to or asked to increase/decrease the size of redo log files as log switches creating contentions at the database. For example, by increasing the redo log file size, the number of log switches can be decreased which […]
Step by Step guide for Schema Refresh using DataPump Utility Oracle Data Pump is a high-speed data movement utility provided by Oracle (10g onwards). It’s an extension to the old EXP and IMP utility with improved performance and enhanced security features. Here we are performing a schema refresh activity using Datapump: PARAMETERS SOURCE TARGET DATABASE […]
To Check the Object count of a Schema in Oracle Oracle object types are user-defined data types that make it possible to shape real-world entities such as customers and supply orders as objects in the database.Underneath the object layer, data is stored in a tabular format, that is in rows and columns but we can […]
Recent Comments