数据库导入dmp文件

oracle数据库导入

新建用户

create user xj_dna_pdb IDENTIFIED BY xj_dna_pdb;

赋予权限

grant create table to xj_dna_pdb;
grant create session to xj_dna_pdb;
grant dba to xj_dna_pdb;
grant all privileges to xj_dna_pdb;

执行导入命令

imp xj_dna_pdb/xj_dna_pdb@ip/orcl file=/home/oracle/bsdna.dmp full=y ignore=y

postgresql

创建用户

create user dna_bk with password 'dna_bk';

创建新库

create database dna_bk owner dna_bk;

赋予权限

grant all privileges on database dna_bk to dna_bk;

导入命令

psql -h localhost -p 5432 -U dna_bk -d dna_bk -f D:\226\dna_bk2.dmp