Oracle 挂起事务的处理
SQL> conn system/manager
Connected.
SQL> select name from v$datafile where rownum=1;
NAME
------------------------------------------
D:\ORACLE\ORADATA\ORA10\SYSTEM01.DBF
SQL> drop tablespace t2m including contents and datafiles;
drop tablespace t2m including contents and datafiles
*
ERROR at line 1:
ORA-00959: tablespace 'T2M' does not exist
SQL> CREATE TABLESPACE T2M DATAFILE 'D:\ORACLE\ORADATA\ORA10\T2M.DBF'
2 SIZE 1M AUTOEXTEND OFF