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
Oracle SQL*Loader
Published by :
Obay Salah , November 19, 2024
We used the Data Pump to read, write and send data from one database to another, but all the data that was dealt with was actually in Oracle proprieta... 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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Export Table Using Export Utilities
Published by :
Obay Salah , November 19, 2024
The user in the database can export the tables he owns, and the database administrator can export all the tables in the database.Also, anyone wh... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Use Export Utilities to Export Data
Published by :
Obay Salah , November 19, 2024
Oracle support for this type of export is not recent, but this type of backup is still available, and the options available in this type of back... Continue Reading