Database Connection & DMP File Restore In Oracle Cloud Autonomous database

 1. First we need to login Oracle Cloud Autonomous Database. 

2. Need to create Bucket to store DMP file that we want to restore in database.
            =>Storage----Bucket---Create Bucket
            => From Bucket Object Select Upload Button to Upload DMP File.
            => Create ATP (Autonomous Transaction Processing) Database.

3. Connect Autonomous Database Using SQL Developer :
            => From Autonomous Database -> DB Connection Download client credentials (Wallet).
           => From SQL Developer Select New Connect & Select Connection Type is Cloud Wallet.
           => IN SQL Developer DBA Section select Import Jobs from Data Pump.

4.Important SQL Command :

        =>create user mrhs  identified by Ripon#123456 account unlock;
        =>create user hpp  identified by Ripon#123456 account unlock;

        =>alter user mrhs identified by Ripon#123456 account unlock;
        =>alter user HRMS identified by Ripon#123456 account unlock;

        =>GRANT CONNECT TO HRMS;
        =>GRANT create table  TO HRMS;
        =>DROP USER MRHS CASCADE;