The SCOTT schema is a small Oracle database schema that allows you to play around with several tables. To see whether the SCOTT schema is installed in your database, you can log in as the SYSDBA and issue this query:
SELECT * FROM DBA_USERS WHERE USERNAME = ‘SCOTT’
If no results return, you need to install the schema. Oracle provides a SCOTT installation script, typically found under %ORACLE_HOME%rdbmaadminscott.sql. To execute it, log in as the SYSDBA from SQLPLUS and run it.
sqlplus / as sysdba
SQL>@?/rdbms/admin/scott
(the “?” will be interpolated to %ORACLE_HOME%)