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 explain how to create a user. The person who will create a user in the database must have “CREATE USER” …

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 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 …

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. …

In today’s article, I will give information about the Data Export and Export processes. In order for us to export with the expdp tool: We …

In today’s article, I will be explaining how to do Partition Table Export AND Import in 3 steps. 1. We export the PARTITIONED TABLE, which …

We can import an object from the database to a different database and a different tablespace with a different schema. 1. First, let’s get this …

Instead of rewriting the commands each time, we can use a parameter file to export/Import with Data Pump. 1. First we create the parameter file. …