1
Chapter 13
Database Administration
Database Systems:
Design, Implementation, and
Management, Seventh Edition, Rob
and Coronel
2
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
3
Oracle Database Administration
Tools
4
4
The Default Login
5
5
Ensuring an Automatic RDBMS
Start
6
6
Creating Tablespaces and
Datafiles
7
7
Creating Tablespaces and
Datafiles (continued)
8
8
Managing the Database Objects: Tables,
Views, Triggers, and Procedures
9
9
Managing Users and
Establishing Security
10
10
Managing Users and
Establishing Security (continued)
11
11
Customizing the Database
Initialization Parameters
12
12
Creating a New Database
13
13
Creating a New Database
(continued)