dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/oracle11g/oradata/dw/sysaux01.dbf'
SIZE 325M REUSE
DEFAULT TABLESPACE USERS01
DATAFILE '/u01/oracle11g/oradata/dw/users01.dbf'
SIZE 500M REUSE
DEFAULT TEMPORARY TABLESPACE temp01
TEMPFILE '/u01/oracle11g/oradata/dw/temp01.dbf'
SIZE 100M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u02/oracle11g/oradata/dw/undotbs01.dbf'
SIZE 400M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
After the create database command completes successfully, the database is mounted and
opened for use.
652 Oracle Database 11g DBA Handbook
9. Create additional tablespaces for users, indexes, and applications.
10. Build data dictionary views with the supplied scripts catalog.sql and catproc.sql found
in $ORACLE_HOME/rdbms/admin. The script catalog.sql creates views against the data
dictionary tables, dynamic performance views, and public synonyms for most of the views.
The group PUBLIC is granted read-only access to the views. The script catproc.sql sets
up PL/SQL.
11. Back up the database either using a cold backup or using Recovery Manager (RMAN).
In case of a database failure in the early stages of deployment, you have a complete
and running database to fall back on, and most likely you will not have to re-create the
database from scratch.
Index
eliminating the need to query undo
segments, 128??“129
eliminating unnecessary sorts, 128
entity relationship (E-R) diagram, 134
execution plans, 135
goals, 134
hinting where needed, 129
keeping statistics updated, 129
materialized views, 131
maximizing throughput in the
environment, 129??“130
parallelism, 131
partitions, 130??“131
physical database diagram, 134
security requirements, 134??“135
space requirements, 134
standard deliverables, 133??“135
storing data the way users will query
it, 127
stretch goals, 134
telling the database what it needs to
know, 129
testing, 131??“133
using a larger database block size, 130
using disk caching, 129??“130
using fewer, faster processors, 130
using the right indexes, 127
See also iterative development;
package development
*_TABLESPACES, 552
2PC, 602??“603
A
abstract datatypes, 150??“151
indexing attributes, 156??“157
security for, 154??“156
using object views, 151??“154
ADR.
Pages:
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956