Oracle Database Administration

oracle database administration

This section covers the common Oracle Database administration tasks.  If you are an Oracle Database Administrator who wants to get grips with Oracle quickly and effectively, then this section is for you.

This Oracle Database administration section is also highly beneficial if you are a developer or project leader who is interested in knowing more about the Oracle Database system. It will enable you to work more closely and cooperatively with your Oracle database administrators.

Section 1. Oracle Database Architecture

  • Oracle Database Architecture – learn about the Oracle Database architecture and its components.
  • Oracle Listener – introduce the Oracle Listener and show you how to manage the Oracle Listener such as starting, stopping, and checking its status.

Section 2. Database Administrative Tasks

Section 3. Managing Tablespaces

  • Oracle tablespace – introduce you to the Oracle tablespace and how Oracle uses tablespaces to store data.
  • CREATE TABLESPACE – show you how to create a new tablespace in the database.
  • DROP TABLESPACE – learn how to remove a tablespace from the database.
  • Extend Tablespace – describe various ways to extend the size of a tablespace.
  • Temporary Tablespace – introduce you to temporary tablespaces and show you how to manipulate temporary tablespace effectively.
  • Tablespace Group – learn about Oracle temporary tablespace group and how to use the tablespace group more effectively to optimize internal Oracle operations.

Section 4. Users & Privileges

Section 5. Roles

  • CREATE ROLE – show you how to group object or system privileges into a role and grant the role to users.
  • SET ROLE – enable and disable roles for your current session.
  • ALTER ROLE – modify the authorization needed to enable a role.
  • DROP ROLE – learn how to remove a role from the database.

Section 6. User Profiles

  • CREATE PROFILE – describe how to create a user profile, which is a set of limits on database resource and password, and assign the profile to a user.
  • ALTER ROLE – show you how to modify the resource limit and password management in a user profile.
  • DROP PROFILE – show you how to delete a profile from the Oracle Database.

Section 7. Data Migration

  • External Tables – show you how to access data from a flat-file as if it were in a table.
  • SQL*Loader – describe steps on how to load data from a flat-file into a table.
  • Data Pump Export – learn step by step how to unload data (and meta-data) from the database.
  • Data Pump Import – guide you on how to load data from an export dump file set into the database.

Section 8. Database Links

  • Create a database link – show you how to create a database link that allows you to access tables and views from a remote database.
  • Alter database link – learn how to update the current password of a user of a database link.
  • Drop a database link – describe how to remove a database link from the database.

Section 9. Useful Tips

Was this tutorial helpful?