DB스토리

Database drop table query version query transaction query Restoring tables from the Recycle Bin --Rename S SCOTT> create table emp18 as select * from emp; Table created. S SCOTT> drop table emp18; Table dropped. S SCOTT> create table emp18 as select * from emp; Table created. S SCOTT> show recyclebin ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME ---------------- ---------------------------..

--Flashback mode 로 전환 하는 절차 ---- OMF 모드에서. --1. 모드 확인 S SYS> select log_mode, flashback_on from v$database; LOG_MODE FLASHBACK_ON ------------ ------------------ ARCHIVELOG NO --2. mount S SYS> shutdown immediate --3 mount 모드로 S SYS> startup mount S SYS> alter database flashback on; Database altered. --4. open S SYS> alter database open; Database altered. --5 . 동작 확인 S SYS> show parameter db_rec..