Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Loss of a Non-SYSTEM Data File
Published by :
Obay Salah , November 19, 2024
It is a Datafile that does not belong to System Tablespace or Undo Tablespace, the moment Non-SYSTEM Datafile is lost, users receive error messages st... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Full Database Recovery
Published by :
Obay Salah , November 19, 2024
In this scenario we assume that we have lost all the database files (Data Files & Redolog Files & Control Files), the database is runnin... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Cold Backup
Published by :
Obay Salah , November 19, 2024
The figure above explain the cold backup and recovery process.1- Shutdown: As we mentioned earlier, the cold backup process is done after t... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Physical Backup
Published by :
Obay Salah , November 19, 2024
The figure shows the types of Oracle database backups (Physical & Logical & RMAN),In this chapter we will talk about physical backup and... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Import Database Using Data Pump
Published by :
Obay Salah , November 19, 2024
The database can be imported by Data Pump from the export file.impdp SYSTEM/SYS dumpfile=FULL1.dmp directory=direct FULL=Y This is how we import... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Import Schema Using Data Pump
Published by :
Obay Salah , November 19, 2024
Let's assume we have a new user named NEW, and we want to import the user VBS object data from the export file for user NEW.impdp NEW/NEW dumpfi... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Import Table Using Import Utilities
Published by :
Obay Salah , November 19, 2024
Let us assume here that the database administrator wants to import the EMPLOYEE table from the export file to the VBS user, knowing that the EMP... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Export Schema Using Export Utilities
Published by :
Obay Salah , November 19, 2024
It is an export of all objects in a specific schema or set of schemas so that a user cannot export another schema unless he has the FULL_EXP_DAT... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Use Import Utilities to Import Data
Published by :
Obay Salah , November 19, 2024
The import process is the reverse process of the export process, through which we can import data and objects from the export file to the databa... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Export Tablespace Using Export Utilities
Published by :
Obay Salah , November 19, 2024
Is it possible to export Tablespace from one database to another? Yes, but only the database administrator can export Tablespaces, or in other w... Continue Reading