SCOTT
Scott is a database user used for demonstration purposes containing the famous EMP, DEPT, BONUS and SALGRADE tables. According to legend, this account was named after Bruce Scott (co-author and co-architect of Oracle v1 to v3) and the password was the name of his daughter's cat, Tiger.
|
|
Starting with Oracle 9i additional sample/demo schemas are available. These schemas contains additional database objects to allow demonstration of newer database features. They are:
- HR - Human resources, basic topics, supports Oracle Internet Directory
- OE - Order entry, intermediate topics, various datatypes
- PM - Product media, used for multimedia data types
- QS - Queued shipping, shows advanced queuing (renamed IX in Oracle 10g)
- SH - Sales history, large amount of data, analytic processing
[edit] Install
The scott/tiger demo is not automatically installed as was the case with earlier Oracle versions. To install the SCOTT schema into your database, run one of the following scripts from a DBA account:
SQL> @ ?/rdbms/admin/scott.sql SQL> @ ?/sqlplus/demo/demobld.sql SQL> @ ?/rdbms/admin/utlsampl.sql
[edit] Log in
Log in with user "scott" and password "tiger". Example:
$ sqlplus scott/tiger
If the SCOTT account is locked, you can unlock it with the following command:
SQL> ALTER USER scott ACCOUNT UNLOCK;
[edit] Also see
Bruce Scott - Scott schema was named after him
| Glossary of Terms | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # |
