3,491
社区成员
发帖
与我相关
我的任务
分享
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> create undo tablespace myundotbs datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\MYUNDOTBS01.DBF' size 50M;
Tablespace created
SQL> alter system set undo_tablespace=myundotbs;
System altered
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string MYUNDOTBS
SQL> alter tablespace undotbs1 offline;
Tablespace altered
SQL> SELECT t.tablespace_name, t.status FROM dba_tablespaces t;
TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
UNDOTBS1 OFFLINE
SYSAUX ONLINE
TEMP ONLINE
USERS ONLINE
EXAMPLE ONLINE
MYUNDOTBS ONLINE
7 rows selected
SQL> insert into t values(20);
1 row inserted
SQL> commit;
Commit complete
SQL>