Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

 

   
  Oracle Tips by Burleson

OCP Instructors Guide for Oracle DBA Certification

Chapter 10 - Ease of Administration

Proceduralize the Change Request Process

  • Oracle Database Change Request Form – used for requesting physical changes to the Oracle database environment.  The form will be used for requesting both system changes (i.e. modifying rollback segments, temporary tablespaces, default tablespaces) and object changes (adding new columns, creating new indexes, etc.).

The Oracle Database Change Request Form contains the following information pertinent to Oracle change requests:

  • Schema owner of object to be changed.
     

  • Object name to be changed.
     

  • Object type (i.e. table, index, view) of the object to be changed.
     

  • Detailed description of change requested.

  • Oracle Migration to Production Request Form - used for requesting the migration of Oracle objects (databases, tablespaces, tables, indexes, etc.) from test to production.

The Oracle Migration to Production Form contains the following information pertinent to the object migration process:

  • Object name of the object to be migrated.
     

  • Object type for the object to be migrated.
     

  • The name of the database the object will be migrated from (source database).
     

  • The name of the database the object will be migrated to (target database).
     

  • A freeform area for special processing required during the migration process.


The above text is an excerpt from:


OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
Administration Techniques

ISBN 0-9744355-3-8

by Christopher T. Foot
 

http://www.rampant-books.com/book_2003_2_OCP_print.htm


Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster



Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks