Listing 1 spcreate.sql
$> sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Mon Jun 26 18:49:51 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> @spcreate;
... Installing Required Packages
Package created.
Grant succeeded.
View created.
Package body created.
Package created.
Synonym created.
Grant succeeded.
View created.
Synonym created...
...Synonym created.
... Creating PERFSTAT user ...
Choose the PERFSTAT user's password.
Not specifying a password will result in the installation FAILING
Specify PERFSTAT password
Enter value for perfstat_password: perfstatpass
PL/SQL procedure successfully completed.
User created....
....Grant succeeded.
Below are the list of online tablespaces in this database.
Decide which tablespace you wish to create the STATSPACK tables
and indexes. This will also be the PERFSTAT user's default tablespace.
Specifying the SYSTEM tablespace will result in the installation
FAILING, as using SYSTEM for performance data is not supported.
TABLESPACE_NAME CONTENTS
------------------------------ ---------
DRSYS PERMANEN
PERFSTAT PERMANENT
TEMP TEMPORARY
TOOLS PERMANENT
UNDOTBS UNDO
USERS PERMANENT
XDB PERMANENT
7 rows selected.
Specify PERFSTAT user's default tablespace
Enter value for default_tablespace: perfstat
Using perfstat for the default tablespace
PL/SQL procedure successfully completed.
User altered.
User altered.
Choose the PERFSTAT user's temporary tablespace.
Specifying the SYSTEM tablespace will result in the installation
FAILING, as using SYSTEM for the temporary tablespace is not recommended.
Specify PERFSTAT user's temporary tablespace.
Enter value for temporary_tablespace: temp
Using temp for the temporary tablespace
PL/SQL procedure successfully completed.
User altered.....
Creating Package STATSPACK...
Package created.
No errors.
Creating Package Body STATSPACK...
Package body created.
No errors.
NOTE:
SPCPKG complete. Please check spcpkg.lis for any errors.
|