z

* Sample Scheme Install

> sqlplus /nolog
sql>conn sys/패스워드@SERVICENAME OR SID [as sysdba]

1) scott 유저의 생성 및 권한부여

SQL> create user scott identified by tiger
2 default tablespace users
3 temporary tablespace temp;

SQL > grant connect , resource to scott;

2) Sample Table Install ($ORACL_HOME/sqlplus/demo 설치 스크립트 저장소)

> sqlplus scott/tiger

SQL>@?/sqlplus/demo/demobld

3) 설치확인
> sqlplus scott/tiger

SQL> select * from tab;

AND