ORACLE

In today’s article I will be explaining how we can Authorize the User with ‘WITH GRANT OPTION’. When Grant is given with Grant Option, the …

In today’s article, I will introduce the “Virtual Private Database” feature, which is one of the security policies offered by Oracle. With Virtual Private Database, …

In today’s article, I will explain how to create a user. The person who will create a user in the database must have “CREATE USER” …

In this article, we will introduce the DBMS_AUTO_INDEX feature, which acts with the autonomous database policy first on the database side and then in the …

In today’s article, we will learn how long the Database software and Server have been running with the help of the uptime command. We can …

In today’s article, I will be explaining how to shrink the tables in the Oracle database. One of the issues that we, as database administrators, …

In today’s article, I will explain the Abort, Normal, Immediate, Transactional and Startup Force commands to close the oracle database. Shutdown Abort: 1. It is …

In today’s article, we will be cover the Database Opening Steps, Nomount, Mount and Open. Nomount: 1. The parameters in the spfile parameter file are …

Today, we will examine the AHF tool offered by Oracle, which offers us the tools we used as orachk and exachk with more advanced features. …

In today’s article, I will cover you about the Data Import process and the parts to pay attention to in this process. IMPORT PROCESS 1. …