2 Comments

Free OCI Learnings/Certifications From Oracle along with Enroll steps for Certification 5 (3)

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 […]

Loading

0 Comments

Basics Of User Management in Oracle 5 (1)

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( […]

Loading

0 Comments

Step by Step Apply Patch on Oracle DB Home (January 2021) 5 (1)

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 […]

Loading

0 Comments

Table Refresh Using EXPDP-IMPDP Datapump Command 0 (0)

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 […]

Loading

4 Comments

Full Database Refresh Using EXPDP-IMPDP Datapump command 5 (4)

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 […]

Loading

4 Comments

Basic Linux Commands For Daily Usage 4.8 (4)

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, […]

Loading

0 Comments

Target Blackouts in OEM13c using EMCTL 5 (3)

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 […]

Loading

4 Comments

ADD-DROP Redo log files in Oracle Database 5 (4)

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 […]

Loading

2 Comments

Schema Refresh Using EXPDP-IMPDP command 5 (2)

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 […]

Loading

0 Comments

How to check object count of a schema in Oracle 5 (1)

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 […]

Loading