Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Database Role
Published by :
Obay Salah , November 19, 2024
Imagine with me that you are working as a database administrator with more than 1000 users, these users are at different levels of permissions,... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Users Privileges
Published by :
Obay Salah , November 19, 2024
All the users we created in the previous scenarios cannot connect to the database let alone perform any other tasks as they do not have permissi... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Authentication Type
Published by :
Obay Salah , November 19, 2024
It is the method of verifying users to access the database. At the moment of creating the user, the verification method must be chosen: -Passwor... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Tablespace Quota
Published by :
Obay Salah , November 19, 2024
It is the share available to the user to create objects in the Tablespaces and without it the user is unable to create any object.Therefore, the... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Create and Manage Oracle Users
Published by :
Obay Salah , November 19, 2024
The basic idea is that access to the database requires the presence of a user who has access authority, otherwise the database cannot remain ava... Continue Reading
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