oracle导入dmp备份文件
1.创建表空间
CREATE SMALLFILE TABLESPACE "TABLESPACE_PDB(表空间名)" DATAFILE
'/oradata/oracle/tablespace_pdb.dbf(保存路径)'
SIZE 3000M
AUTOEXTEND ON NEXT 1000M
LOGGING
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
chmod 773 tablespace_pdb.dbf
2.创建用户
create user oracle_test
identified by "oracle123"
default tablespace "TABLESPACE_PDB"
temporary tablespace "TEMP"
profile DEFAULT;
3.用户授权
grant dba to oracle_test;
4.dmp文件导入
su oracle
imp oracle_test/oracle123@localhost:1521/pora12c1.domain file=/home/oracle/sz_bak_2019_02_13.dmp full=y