Docstoc

Database Administration

Document Sample
Database Administration Powered By Docstoc
					       Chapter 13
   Database Administration

      Database Systems:
  Design, Implementation, and
Management, Seventh Edition, Rob
          and Coronel              1
           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




                                          2   2
Oracle Database Administration
            Tools




                            3   3
The Default Login




                    4   4
Ensuring an Automatic RDBMS
            Start




                          5   5
Creating Tablespaces and
        Datafiles




                           6   6
Creating Tablespaces and
  Datafiles (continued)




                           7   7
Managing the Database Objects: Tables,
   Views, Triggers, and Procedures




                                     8   8
Managing Users and
Establishing Security




                        9   9
      Managing Users and
Establishing Security (continued)




                                10 10
Customizing the Database
 Initialization Parameters




                             11 11
Creating a New Database




                          12 12
Creating a New Database
       (continued)




                          13 13

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:16
posted:3/8/2010
language:English
pages:13