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