更换Oracle备份数据文件

应用背景：需要查看和修改一下Interlib中的数据，所以要反复的将备份数据进行导入和清空。整理一下步骤

1. 删除tablespace

   drop tablespace interlib including contents;

2. 删除User

   drop user interlib cascade;

3. 重新创建表空间和用户

   create tablespace interlib datafile'/opt/oracle/oradata/interlib/interlib.dbf' size 2048m;

   alter tablespace interlib add datafile'/opt/oracle/oradata/interlib/interlib1.dbf' size 2048m;

   create user interlib identified by ***** default tablespace interlib;

   grant dba to intelrib;

4. 导入数据

   imp interlib/***** full=y file=/opt/backup/backup.dmp

转载于:https://www.cnblogs.com/zhengcong/p/4074694.html