更换Oracle备份数据文件
时间:2022-03-14 01:59
应用背景:需要查看和修改一下Interlib中的数据,所以要反复的将备份数据进行导入和清空。整理一下步骤
- 删除tablespace
drop tablespace interlib including contents;
- 删除User
drop user interlib cascade;
- 重新创建表空间和用户
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;
- 导入数据
imp interlib/***** full=y file=/opt/backup/backup.dmp