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窗口将事务提交或回滚,然后停机;
2、在其它的窗口执行shutdown immediate停机。
转载于:https://blog.51cto.com/6205351/1530537