alter system set undo_tablespace=undotbs1 scope=both;
alter tablespace UNDOTBS4 offline;
drop tablespace UNDOTBS4 including contents and datafiles cascade constraints;
58数据库重建表空间记录
标签：
58数据库重建表空间记录
create undo tablespace undotbs1 datafile ‘/home/oracle/product/11.2.0/oradata/srcl/undotbs01.dbf‘ size 10240m reuse;
alter system set undo_tablespace=undotbs1 scope=both;
alter tablespace UNDOTBS4 offline;
drop tablespace UNDOTBS4 including contents and datafiles cascade constraints;
alter system set undo_tablespace=undotbs1 scope=both;
alter tablespace UNDOTBS4 offline;
drop tablespace UNDOTBS4 including contents and datafiles cascade constraints;