SCOTT
From Oracle FAQ
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 (one of the original Oracle employees) 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
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 the following script from a DBA account:
SQL> @ ?/rdbms/admin/utlsampl.sql
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;
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 | # |
