oracle中ora_14501,Oracle中的ORA-01548: active rollback segment '_SYSSMU1$' found

Oracle中的ORA-01548: active rollback segment '_SYSSMU1$' found

1、在创建新的undo tablesapce “undotbs2”后，删除旧的undo tablespace

15:12:49 SYS@ prod>ALTER tablespace undotbs1 offline immediate;

Tablespace altered.

Elapsed: 00:00:00.15

报以下错误：

15:12:59 SYS@ prod>drop tablespace undotbs1 including contents and datafiles;

drop tablespace undotbs1 including contents and datafiles

*

ERROR at line 1:

ORA-01548: active rollback segment '_SYSSMU1_3780397527$' found, terminate dropping tablespace

Elapsed: 00:00:00.05

2、通过spfile生成pfile

15:13:08 SYS@ prod>create pfile from spfile;

File created.

Elapsed: 00:00:00.11

15:14:12 SYS@ prod>shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

在initprod.ora 文件加入以下隐含参数&#