sys@ora10g> create table t (x number); Table created. sys@ora10g> insert into t values (1); 1 row created. 2.使用immediate选项关闭数据库 sys@ora10g> shutdown immediate; ORA-01097: cannot shutdown while in a transaction - commit or rollback first OK,错误提示“ORA-01097”已经给出,提...
ORA-01097停机报错 SQL> insert into emp2 select * from emp2; 14 rows created. SQL> shutdown immediate ORA-01097: cannot shutdown while in a transaction - commit or rollback first 因为在本机执行DML操作后没有提交,导致数据库无法停机, 解决办法: 1、在本事务session窗口将事务提交或回滚,然后停机...