http://blog.itpub.net/31394774/viewspace-2220984/
-新建一个undo表空间
create undo tablespace UNDOTBS2 datafile '/app/oracle/oradata/BIEEDB/undotbs02.dbf' size 15G autoextend on next 100M maxsize 30G;
alter system set undo_tablespace=UNDOTBS2 scope=both;
alter tablespace UNDOTBS1 offline;
--删除表空间前腰确保表空间里面的内容都已过期:当结果为空时才可以删除表空间
select extent_id, status from dba_undo_extents where tablespace_name='UNDOTBS1' and status <> 'EXPIRED';
--重启数据库
通过命令行方式登录数据库,
[root$smserver] sqlplus /nolog
[root$smserver]conn / as sysdba
[root$smserver] shutdown immediate;
[root$smserver] startup
drop tablespace UNDOTBS1 including contents and datafiles;
undo表空间的切换:
1、先检查现在正在使用的undo表空间:
SQL> show paramet