01A
Less than 1 minute
01A κ΄λ ¨
βοΈμ€μΉ
μ°Έκ³ μ¬μ΄νΈ : http://keep-cool.tistory.com/23
μ μ
CONNECT sys/oracle AS sysdba
sys
κ³μ μΌλ‘ λ‘κ·ΈμΈνλ λͺ λ Ήμ΄μ΄λ©°, μ¬κΈ°μoracle
μ λ°μ΄ν°λ² μ΄μ€λ₯Ό μ€μΉν λ μ€μ ν΄μ£Όμλ€ λΉλ°λ²νΈμ΄λ€.
ALTER USER hr IDENTIFIED BY hr ACCOUNT UNLOCK;
hr
κ³μ μ λΉλ°λ²νΈλ₯Όhr
λ‘ μ€μ νκ³ , μ 겨μλhr
κ³μ μ μ κΈμ ν΄μ νλ λͺ λ Ήμ΄μ΄λ€.
sys
κ³μ μΌλ‘ λ‘κ·ΈμΈν΄μΌλ§ μμ λͺ λ Ήμ΄λ₯Ό μ¬μ©ν μ μκΈ° λλ¬Έμsys
κ³μ μ λ¨Όμ λ‘κ·ΈμΈν κ²μ΄λ€.
λΉλ°λ²νΈ κΈ°μ΅ λͺ»ν μ
sqlplus /nologx
conn /as sysdbxa
μννμΈ
SELECT * FROM dba_users
*.sql
νμΌ μ κ·Ό
- π__κ²½λ‘__:
C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin\scott.sql
κ°λ
DBMS
: Database Management System. (μ ν©μ± 보μ₯, λ°±μ κ³Ό 볡ꡬ, μ§μ μ²λ¦¬ λ° λ³΄μ)SQL
DML
:insert
,update
,delete
DCL
:revoke
,grant
DDL
:alter
,create
μ°Έμ‘°: μ€λͺ λ§ν¬01, μ€λͺ λ§ν¬02
MISC
set linesize 200
col table_name for a13
https://m.blog.naver.com/hsm119216/30094842888