Database Administration

1
Chapter 15

• Database Administration
• Database Systems Design, Implementation, and
  Management, Seventh Edition, Rob and Coronel

2
The DBA at Work Using Oracle for Database
Administration

• Execution of tasks tends to be DBMS-and
  operating-system specific
• This section is brief introduction to way some
  typical DBA tasks would be performed in Oracle

3
Oracle Database Administration Tools
4
The Default Login
5
Ensuring an Automatic RDBMS Start
6
Creating Tablespaces and Datafiles
7
Creating Tablespaces and Datafiles (continued)
8
Managing the Database Objects Tables, Views,
Triggers, and Procedures
9
Managing Users and Establishing Security
10
Managing Users and Establishing Security
(continued)
11
Customizing the Database Initialization
Parameters
12
Creating a New Database
13
Creating a New Database (continued)