摘要：SQL> CREATE TABLE test_fb_table (2 ID int,3 VALVARCHAR2(10)4);Table created.SQL> INSERT INTO test_fb_tableVALUES (1, 'TEST');1 row created.SQL> commit;Commit complete.假如数据被错误的删除/更新需要检索某个时间点上，表原有的数据。SQL> SELECT TO_CHAR(sysdate, 'yyyy-mm-dd hh24:mi:ss') FROM dual;TO_CHAR(SY 阅读全文

摘要：select sess.sid, sess.serial#, lo.oracle_username, lo.os_user_name, ao.object_name, lo.locked_mode from v$locked_object lo, dba_objects ao, v$session sesswhere ao.object_id = lo.object_id and lo.session_id = sess.sid;解锁alter system kill session '1089,1'; 阅读全文