oracle还原dmp数据库
1.CMD登录sqlplus
sqlplus system/123456@orcl as sysdba
2通过sql,查询数据库表空间存放位置;
select file_name from dba_data_files;
3.创建数据库临时表空间;(注意空格符)
create temporary tablespace abctmp
tempfile 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\file_abctmp.dbf'
size 50m
autoextend on next