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 file=/home/oracle/xj_dna_pdb.dmp full=yes
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