SELECT * FROM dba_objects where OBJECT_NAME LIKE 'LOG_5%' AND owner = 'Geoff';

select * from v$sqlarea b
   where b.FIRST_LOAD_TIME between '2022-05-31/21:30:00' and'2022-05-31/23:30:00'` 
    order by b.FIRST_LOAD_TIME;

SELECT * FROM recyclebin_temp WHERE TYPE = 'TABLE' ORDER BY droptime DESC;

flashback TABLE LOG_505 to before drop RENAME to LOG_505_temp ;

--查詢當(dāng)前數(shù)據(jù)庫表中的最大ID
SELECT ID FROM WORK_DUTY_LOG_505_temp ORDER BY ID DESC;
--修改序列步長至最大ID
ALTER sequence SEQ_WORK_DUTY_LOG_505 INCREMENT BY 3538;
SELECT SEQ_WORK_DUTY_LOG_505.nextval FROM dual;
--恢復(fù)序列步長為默認(rèn)值1
ALTER sequence SEQ_WORK_DUTY_LOG_505 INCREMENT BY 1;

--創(chuàng)建觸發(fā)器，并將表中數(shù)據(jù)手動(dòng)插入到從回收站恢復(fù)的臨時(shí)表中
CREATE OR REPLACE TRIGGER T_WORK_DUTY_LOG_505 BEFORE INSERT ON WORK_DUTY_LOG_505_temp REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
begin
 select SEQ_WORK_DUTY_LOG_505.Nextval into:new.ID from dual;  --base_login_user_id序列名稱  --ID給ID裝上序列
end;

--刪除觸發(fā)器
DROP TRIGGER T_WORK_DUTY_LOG_505;
--將臨時(shí)表中整合完成的數(shù)據(jù)恢復(fù)至原數(shù)據(jù)庫表中
INSERT INTO  WORK_DUTY_LOG_505 SELECT * FROM WORK_DUTY_LOG_505_temp
--查詢確認(rèn)
SELECT * FROM WORK_DUTY_LOG_505 ORDER BY ID DESC;