ORA-03113 is a quite a common error. Let us take a deep dive into it Issue ORA-03113: end-of-file on communication channel Cause: The connection between the Client and Server process was broken. It may also happen if the external agent extproc crashes for some reason. Action: There was a communication error that requires further investigation. […]
How to Create User in Oracle and Assign privileges
We will be posting information on User access and security in oracle database.This post will give good information on Create User in Oracle , System Privileges and Oracle Object Privileges,How to grant the privileges to users,How to show all privileges from a user in oracle CREATE USER statement It is employed to create a user […]
How to use Decode in Oracle
Introduction to Oracle sql decode In this section we will discuss about Oracle decode processing which is very important aspect in Oracle sql statement Oracle decode is the method in Oracle database to transform data values for one value to another which is better to understand. Oracle Decode transform data values at retrieval time. It is a […]
windows grep equivalent to search text
We use grep command to search for strings in the Unix Operation system. Now when we work on Windows, we don’t have grep command in Windows, So We often look for grep equivalent in windows. This problem can be solved on Windows using these three free tools. These tools can do many works same as […]
How to shrink datafile in Oracle Database
We sometimes have shrink datafile in oracle to reclaim filesystem space.We can do it like Alter database datafile <datafile name > resize <smaller size>; Many times we may get the below error as the extent may spread out on the outer of the file ORA-03297: file contains used data beyond requested RESIZE value”. To resolve […]
Practice Oracle Cloud Infrastructure 1Z0 932 /1072 questions
Oracle Cloud Infrastructure is heavily being used in the Industry.It is a IaaS/PaaS Offering of Oracle corporation Having a certification on Oracle cloud infrastructure add lot of value to your Resume. Oracle Cloud Infrastructure Certification Examination checks your knowledge on Virtual Cloud Network, File storage , Compute Machine, Oracle database as a service, Identity Access […]
