Notes about Oracle import (create a tablespace, create a user, and authorize the user)

Sometimes the database cannot be imported smoothly, and a bunch of errors are reported.
Probably because the user does not exist, or the user's tablespace does not.
Check the error message and you will know.
The following is an example of creating a tablespace. There was a problem at the beginning. After the creation, the import can be completed successfully.

 

Exp uuu/UUU@101.123.30.128: 1521/orcl file = c: \ 11820121107.dmp owner = (edm_base) exp uuu/UUU@101.123.30.128: 1521/orcl file = c: \ 11820121107.dmp exp uuu/UUU@101.123.30.128: 1521/orcl file = c: \ 11820121107.dmp ignore = ycreate tablespace tablespace_db logging datafile 'd: \ Oracle10g \ test_data01.dbf 'size 32 m autoextend on next 32 m maxsize 2048 M extent management local; -- create the user create user uuu identified by "uuu" default tablespace tablespace_db temporary tablespace temp profile default; -- Grant/Revoke role privileges grant connect to uuu; grant DBA to uuu; grant resource to uuu; -- Grant/Revoke SYSTEM privileges grant unlimited tablespace to uuu;/* grant connect, resource, DBA to helpdesk ;*/