User`s guide

Creating a Database
Creating and Upgrading a Database 4-7
4.1.3.3 Installing Data Dictionary Views
Data dictionary views provide easy access to dictionary information. If you want to
use dictionary views, then you must install them by running SQL*Plus, by issuing the
CONNECT / AS SYSDBA
command, and entering the following commands:
SQL> SPOOL filename
SQL> SET TERMOUT OFF
SQL> @$ORAC1120.RDBMS.ADMIN.CATALOG.SQL
Data dictionary views required for Export or Import are also installed in this sequence.
4.1.3.4 Installing Data Dictionary Views for PL/SQL
If you chose not to install the basic PL/SQL package automatically while running
INSTALL.P.SUPER
, then you must perform the following task after the first
STARTUP
, in
order to make PL/SQL available.
Run SQL*Plus, issue the
CONNECT / AS SYSDBA
command, and run the SQL script
RDBMS.ADMIN.CATPROC.SQL
to install the PL/SQL dictionary tables:
SQL>@$ORAC1120.RDBMS.ADMIN.CATPROC.SQL
4.1.3.5 Installing Online Help Messages
To install the online Help facility, enter the following command:
/CALL-PROCEDURE $ORAC1120.INSTALL.P.HELP,(sid [,SYSTEMPW=systempw])
4.1.3.6 Installing the Demo Tables
To install the demo tables, enter the following:
/CALL-PROCEDURE $ORAC1120.INSTALL.P.DEMO,(sid [,SYSTEMPW=systempw])
4.1.3.7 Installing the Sample Schemas
To install the Sample Schemas, enter the following:
/CALL-PROCEDURE $ORAC1120.INSTALL.P.SAMPLES,(sid -
/[,SYSTEMPW=systempw] [,SYSPW=syspw])
The procedure
INSTALL.P.SAMPLES
installs the sample schemas human resources (HR),
order entry (OE), info exchange (IX) and sales history (SH) with the default passwords.
product media (PM) is not supported.
Note: By default, the password for the
SYSTEM
user is
MANAGER
and
the password for the
SYS
user is
CHANGE_ON_INSTALL
. For security
reasons, Oracle recommends that you change these passwords and the
sample schema passwords immediately after installation.
4.1.3.8 Verifying Successful Creation of the Database
To verify that the demonstration database was correctly created, enter the following:
/CALL-PROCEDURE $ORAC1120.INSTALL.P.VERIFY,(sid [,SYSTEMPW=systempw])
If the demonstration database was correctly created, then you see messages like the
following one displayed on the screen:
*SCOTT'S TABLE EMP IS INSTALLED