Oracle 셋업하기

1) Run SQL Command Line

connect hr/hr
// Error (the password will expire within 7 days)

connect system/admin 
// Error (invalid username/password; logon denied) 
// Warning (You are no longer connected to ORACLE.)

conn sys as sysdba 
>> Enter password: sysdba 
>> connected.

show user 
>> USER is "SYS"

alter user system identified by admin; 
>> User altered.

connect system/admin 
>> Connected

alter user hr account unlock; 
>> User altered.

alter user hr identified by hr; 
>> User altered.

connect hr/hr >> connected.

select table_name
from user_tables;
// table 나옴

host
// 위치 나옴 (ex. C:\oraclexe\app\oracle\product\11.2.0\server\BIN>)

exit
show user 
>> USER is "HR"
// user 출력

@job_grades.sql (파일이름)
>> ...Table created. Commit complete.

@sqlplus_demobld.sql
>> ...complete.

select table_name
from user_tables;
>> ... ~ rows selected.