Oracle数据库恢复

drop user test2005 CASCADE;
drop tablespace TEST_DATA01;
drop tablespace TEST_INDEX01;

create tablespace TEST_DATA01 datafile 'D:\soft\Oracle\oradata\orcl\TEST_DATA01.ora' size 2048M autoextend on NEXT 64M MAXSIZE UNLIMITED NOLOGGING EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;
create tablespace TEST_INDEX01 datafile 'D:\soft\Oracle\oradata\orcl\TEST_INDEX01.ora' size 256M autoextend on NEXT 64M MAXSIZE UNLIMITED NOLOGGING EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;

create user test2005 identified by 1 default tablespace TEST_DATA01 temporary tablespace temp;
grant connect,dba,resource to test2005 with admin option;

drop table test2005 

drop tablespace TEST_DATA01;

create tablespace TEST_DATA01 datafile
'D:\soft\Oracle\oradata\orcl\TEST_DATA01.ora'size 256M autoextend on
NEXT32M MAXSIZE UNLIMITED NOLOGGING EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENTSPACE MANAGEMENT AUTO;
　　　
create tablespace TEST_INDEX01 datafile
'D:\soft\Oracle\oradata\orcl\TEST_INDEX01.ora' size 256M autoextend on NEXT 64M MAXSIZE UNLIMITED NOLOGGING EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENTSPACE MANAGEMENT AUTO;
 
create user test2005 identified by 1 default tablespace TEST_DATA01 temporary tablespace temp;
grant connect,dba,resource to test2005 with admin option;
impdp test2005/1@127.0.0.1:1521/orcl file=69test2005-2021-11-02.dmp remap_schema=69test2005:test2005 ignore=y FULL=Y 

 创建一个导出、导入目录
create directory dpdata2 as 'D:\oracle';（该目录必须是事先创建好的，ORACLE并不会自动创建该目录）
给导出用户赋予在指定目录的操作权限，最好以system等管理员赋予。
grant read,write on directory dpdata1 to test;