Undo Management in Oracle Database
Published by : Obay Salah , November 19, 2024
Have you ever thought about the ROLLBACK process? And have you asked yourself how you can undo the modifications that occurred in some fields? E... Continue Reading
Materialized Views
Published by : Obay Salah , November 19, 2024
When we discussed Database Link, we learned how to link one database to another and how to access objects in another database.However, you may s... Continue Reading
Oracle Database Link
Published by : Obay Salah , November 19, 2024
In a single database, users can grant permissions to objects they own to other users. However, if you have more than one database, it is impossi... Continue Reading
Oracle Clients Side
Published by : Obay Salah , November 19, 2024
In order for the Client to connect to the Database Server, it needs to know some information necessary for the success of the connection process... Continue Reading
External Procedures
Published by : Obay Salah , November 19, 2024
It is necessary to prepare the listener to be able to accept and complete the call of external procedures. By preparing the listener, you can ca... Continue Reading
Control Database Access
Published by : Obay Salah , November 19, 2024
Originally, the listener does not set any limits on connecting to the database and serves all requests, while security and blocking are done thr... Continue Reading
Oracle Net Services
Published by : Obay Salah , November 19, 2024
To have a server (Database Server) that contains the database to which all Client Applications or all devices that contain programs that need to... Continue Reading
Oracle Database Auditing
Published by : Obay Salah , November 19, 2024
Database monitoring is part of database security and through the monitoring process we can find many answers to some matters that would remain a... Continue Reading
Oracle Database Security
Published by : Obay Salah , November 19, 2024
There are many steps that a database administrator can take to secure the database, I will mention some of them:1- Protecting the DATA DICTIONAR... Continue Reading
Oracle Database Profile
Published by : Obay Salah , November 19, 2024
It is for managing the password as well as the resources, after how long will the password be terminated? What is the number of failed attempts... Continue Reading