Database

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

Database

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

Database

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

Database

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

Database

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

Database

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

Database

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

Database

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

Database

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

Database

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