create tablespace STNBXYXT datafile 'D:/tablespace/STNBXYXT.dbf' size 500M autoextend on next 50M maxsize unlimited;
--创建用户
create user STNBXYXT identified by STNBXYXT;
--设置表空间给用户
alter user STNBXYXT default tablespace STNBXYXT;
--或者一步执行以上两步
create user sharedb identified by sharedb default tablespace sharedb;
--授予dba权限
grant dba to STNBXYXT;
多种方法导入dpm文件:
1:
plsql导入表
2:
imp NBXYXT/NBXYXT@127.0.0.1:1521/orcl file=E:\NBXYXTDPM\NBXYXT731.dmp full=y
3:利用Navicat Premium工具同步数据