oracle 账号配置密码策略oracle上迁移undo表空间的步骤

oracle 上 迁移 undo 表空间的步骤:

  1 .重建undo 表空间
          SQL> create UNDO tablespace undotbs2
               2  datafile E:ora_dataUNDOTBS02.DBF size 2048m
               3  autoextend on next 1m maxsize 20480m;
                  Tablespace   created
  2 .修改系统设置
      SQL> alter sysoracle账号tem set undo_tablespace= undotbs2;