Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Redo Log File in Oracle Database
Published by :
Obay Salah , November 19, 2024
This file is to record the changes that occur in the database so that the changes that have been committed or not are recorded.We benefit from t... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Change Oracle Database Name
Published by :
Obay Salah , November 19, 2024
Have you ever thought about changing the name of your database? No doubt you have thought about it, but how do you do it? Actually, it is very e... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Control File in Oracle Database
Published by :
Obay Salah , November 19, 2024
It can be called a control file, and it is a binary file, meaning it cannot be read through a text editor, as it is not text, and without it the... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Tutorial - Tablespace
Published by :
Obay Salah , November 19, 2024
1- Create a new Tablespace:CREATE TABLESPACE TEST DATAFILE 'D:\TEST\TEST١.DBF' SIZE 100M NOLOGGING; Since we did not specify the type of Tablesp... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Tablespaces Concepts
Published by :
Obay Salah , November 19, 2024
The database is physically divided into storage files that can be viewed by the operating system, which are the Data files. The database is also... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Opening a Database in Restricted Mode
Published by :
Obay Salah , November 19, 2024
In this mode, users are prevented from entering the database unless the user has the RESTRICTED SESSION PRIVILEGE privilege.In fact, this mode i... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Opening a Database in Read-Only Mode
Published by :
Obay Salah , November 19, 2024
The database is opened in Only Read mode to prevent any modifications to the database, but users can connect to the database and perform queries... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Shutdown Database
Published by :
Obay Salah , November 19, 2024
When closing the database, you must have the SYSOPER OR SYSDBA permission. There are several ways to close the database:1- NORMAL.2- TRANSA... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Startup Database
Published by :
Obay Salah , November 19, 2024
To run the database, you must specify the state in which you want your database to operate:1- NOMOUNT.2- MOUNT.3- OPEN.NOMOUNT:You can run... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Controlling The Database on Windows
Published by :
Obay Salah , November 19, 2024
Imagine that you are the administrator of a huge database, you are required to make this database available to everyone until a specific time, a... Continue Reading