$ORACLE_HOME/rdbms/admin
┌ dmbs*.sql ┐ Oracle에서 미리 제공하는 Package file (이미 실행)
└ prvt*.plb ┘ ex) dbms_rowid.____________(rowid) → 암호를 해독
스펙 / 바디
- 스펙은 공개, 바디는 암호화
utl*.sql → 만들어서 써야 함(일종의 오픈소스)
ex) utlpwdmg.sql → 암호를 검증하는 스크립트
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
※ Shared Lock 메세지
* Undo Data
-> bigemp 테이블 만들어서 실습
57672 rows selected.
※ select * from bigemp order by salary; 쿼리 실행 후 ctrl + c로 중단.
HR1> conn / as sysdba
Connected.
SYS> select tablespace_name, segment_name, status
2 from dba_rollback_segs;
TABLESPACE_NAME SEGMENT_NAME STATUS
------------------------------ ------------------------------ ----------------
SYSTEM SYSTEM ONLINE
UNDOTBS1 _SYSSMU10_4033112442$ ONLINE
UNDOTBS1 _SYSSMU9_3827789179$ ONLINE
UNDOTBS1 _SYSSMU8_3141448595$ ONLINE
UNDOTBS1 _SYSSMU7_2991351813$ ONLINE
UNDOTBS1 _SYSSMU6_3921977746$ ONLINE
UNDOTBS1 _SYSSMU5_1324752763$ ONLINE
UNDOTBS1 _SYSSMU4_1662175826$ ONLINE
UNDOTBS1 _SYSSMU3_866615412$ ONLINE
UNDOTBS1 _SYSSMU2_526994602$ ONLINE
UNDOTBS1 _SYSSMU1_2377010775$ ONLINE
11 rows selected.