1.导出
按用户导出
exp bvdf_aks/bvdf_aks@127.0.0.1:1521/orcl owner=bvdf_aks file=D:\\bvdf_aks_10190708.dmp
2.导入
创建表空间
create tablespace bvdf datafile 'D:\app\zx\oradata\orcl\bvdf' size 2000M;
创建用户
create user bvdf identified by bvdf default tablespace bvdf;
授权
grant connect,resource to bvdf ; grant dba to bvdf ;