Database

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

Database

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

Database

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

Database

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

Database

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

Database

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

Database

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

Database

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

Database

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

Database

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