oracle导入dmp文件

创建表空间

CREATE TABLESPACE THOANEW
LOGGING   
DATAFILE 'C:\app\vincent\oradata\orcl\thoanew.dbf' SIZE 100M REUSE    
                AUTOEXTEND ON    
                NEXT 51200K MAXSIZE 1024M;

创建用户

create user thoa  identified by thoa 
 default tablespace THOANEW TEMPORARY TABLESPACE temp;

alter user thoa quota 1000M on thoa;

赋予权限

grant dba to thoa; 

导入

imp thoa/thoa@192.168.1.14/orcl fromuser=thoa file= 
C:\thoa_db_2019-02-26_1758\thoa_db_2019-02-26_1758.dmp
touser=thoa

*不需要加最后那个';'
这是一条cmd下的命令,不是oracle的plsql的命令,不需要加最后那个';'

alter database datafile 'C:\app\vincent\oradata\orcl\THOANEW.DBF' offline drop  2;

参考:https://www.cnblogs.com/lsjava/p/8598427.html