How to connect as SCOTT

If the SCOTT user is locked, you need to unlock it:

sqlplus sys@orcl as sysdba
alter user scott identified by tiger account unlock;

If the demo tables in the SCOTT schema have not been created, you can create them:
1. Create a copy of the C:\ora102db\RDBMS\ADMIN\scott.sql script:
```
set ORACLE_HOME=C:\ora102db
set PATH=%ORACLE_HOME%\bin;%PATH%
cd /d %ORACLE_HOME%\RDBMS\ADMIN
copy scott.sql scott_orcl.sql
```
2. Edit the copy of the script, adding the TNS alias to the CONNECT statement:
```
CONNECT SCOTT/TIGER@ORCL
```
3. Run the modified script as SYS:
```
sqlplus sys@orcl as sysdba @scott_orcl.sql
```
Connect as SCOTT:
```
sqlplus scott/tiger@orcl
```
(Optional) Do some serious work:
```
select ename from emp order by 1;
```