oracle-databasedatapump

How to restore dump file in Oracle 12c


I want to restore a database in oracle 12c. I have done something for it but while importing data I got some errors about non-existing users in db.Because the database needs some users which must defined in oracle 12c. I created users for db which db needs but in oracle 12 creating user system was changed about session issues. I had to put c## expression in front username and problem still persists. I tried different methods to restore but it wasn't imported all tables and data. I think it's about the user problem.My question how can i create a user same as with the backup db user and restore database.


Solution

  • Based on OP's input via answer to my comments :

    / AS SYSDBA will by default connect to CDB and not your local PDB. There are many ways, however, as of now, you need to first connect to your local PDB as:

    SYS@<pdb service_name> AS SYSDBA
    

    Then execute your CREATE USER and other commands :

    CREATE USER HASTANE IDENTIFIED BY HASTANE DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP; 
    GRANT DBA TO HASTANE; 
    IMP HASTANE/HASTANE FILE=c:\VERI.DMP FULL=Y