Home
Maximum Availability Series
Automated Storage Management (ASM)
Data Guard
Dynamic Reconfiguration
Flashback
Grid Control
Online Redefinition
Real Application Clusters (RAC)
Resumable Transactions
DBA Series
11g New features for DBAs
Audit Vault
Disaster Prevention and RMAN
Managing Terabyte Databases
Oracle Security Workshop
Sarbanes-Oxley & HIPAA Compliance
Developer Series
11g New Features for Developers
Advanced Queuing and Streams
Array Processing and Bulk Binding
Exception Handling
Oracle Forms
Procedures, Functions, & Packages
Security and Fine Grained Access Control
SQL and PL/SQL Tuning
SwingBench Installation & Configuration
Triggers
Fusion Middleware Series
Oracle Application Server
Oracle Identity Management
Independent Classes
Interviewing and Hiring Oracle Pros
Oracle for DB2/UDB DBAs & Developers
Oracle for Informix DBAs & Developers
Oracle for SQL Server DBAs & Developers
Oracle for Sybase DBAs & Developers
UNIX, Linux and vi
Evening Workshops
Constraints
Exception Handling
Functions & Pipelined Table Functions
Interviewing
Linux and UNIX Skills
Loops Cursors and Array Processing
Materialized Views
New Objects
Partitioning
Sarbanes-Oxley - HIPAA Compliance
Triggers
Tuning SQL and PL/SQL
Writing PL/SQL Packages
Writing Stored Procedures
|
|
11g Online Redefinition
|
 |
Why Online Redefinition is
important to your operations.
- An integral part of a
high availability strategy
- Change the definition of
tables, constraints,
indexes, partitions, clusters, triggers, and data
- Converting LONGs to LOBs
- Patch applications
without taking the system off-line
|
The PSOUG's Online
Redefinition class is part
of our Maximum Availability series and is presented as a 1
day
hands-on class.
How is PSOUG's Online Redefinition class different, and we think better,
than anyone else's? To be honest we think it may be the
only one that exists. What we have done is pulled together
all of the capabilities for altering schema objects and
data focusing on most intently on the RDBMS_REDEFINITION
built-in package: First in the Oracle database in version
9.0.1. All student's learn the
material on their own server with Oracle Unbreakable Linux 4 and the
11gR1 database and all labs are hands-on in a class with
no more than 7 other students.
During the class students learn the concepts, architecture,
implications, how to redefine objects and when it is and
is not best practice to do so. The
syllabus, below, shows the topics covered as well as the
fact that this class is hands-on: Not slow death by
PowerPoint. $450/student.
|
|
Day 1
|
| 8:30-9:00am |
Registration |
Join us for coffee and pastries while you register. |
| 9:00-10:00am |
Discussion 1 |
Oracle's
Online Redefinition capabilities allow a DBA to
alter almost every aspect of a running application
without negatively affecting end-users or
violating their SLA (Service Level Agreement).
This discussion will be an overview of the full
range of capabilities and built-in packages that
make Online Redefinition possible. |
| 10:00-10:45am |
Lab 1 |
Redefining
Table
In this first lab students will learn how to alter
tables real-time without taking an application
off-line using the DBMS_REDEFINITION built-in
package. |
| 10:45-11:30am |
Lab
2 |
Redefining
Constraints and Indexes
In this second lab with DBMS_REDEFINITION students
learn to utilize another capability: That of
redefining constraints and indexes while
redefining tables. |
| 11:30-12:00am |
Lab
3 |
Redefining
Triggers
In this second lab with DBMS_REDEFINITION
students learn to utilize another capability: That
of redefining triggers while redefining tables. |
| 1:00-2:15pm |
Lab
4 |
Redefining
Data
This lab completes our work with DBMS_REDEFINITION
focusing on altering data while at the same time
redefining tables, columns, constraints, indexes,
and triggers. We also work with the
DBMS_ERRLOG built-in package, and the utlexcpt.sql
and utlexcpt1.sql scripts. |
| 2:15-3:15pm |
Lab 5 |
Redefining
Types
The built-in package DBMS_UTILITY has a procedure
named CREATE_ALTER_TYPE_ERROR_TABLE that supports
the real-time redefinition of user-defined data
types. In this lab we work with UDTs and the best
practices and restrictions on their redefinition. |
| 3:15-4:30pm |
Lab
6 |
Redefining
PL/SQL Objects
No workshop of online redefinition would be
complete without exploring the capabilities for
redefining a range of PL/SQL objects including
functions, operators, packages, pipelined table
functions, and packages. We do this with the DBMS_DDL.ALTER_COMPILE
built-in package. |
|
|
Instructors |
Dan Morgan is an Oracle Ace Director, a
10g and 11g Beta tester for Oracle, and the instructor of
the Oracle program at the University of Washington since
its inception in 1999. He began his IT career in 1969 with
an IBM 370/145, punch cards, and Fortran IV, and though he
will vigorously deny it, wrote COBOL for a decade before
moving into Oracle about when version 6 hit the market.
In addition to Dan's work at the university he is the
Education Chair of the Puget Sound Oracle Users Group, a
member of UKOUG, and a member of the British-American
Chamber of Commerce in Seattle. He is also a frequent
lecturer at training events and at conferences and has
presented at Oracle OpenWorld on RAC (2005), at Seattle
OracleDay (2004-2007), at numerous government and
corporate training events including Apple Computer,
Argonne National Laboratory, Boeing Commercial Airplane
Group, Dow Jones & Company, Lawrence Livermore
National Laboratory, NASA, T-Mobile, US Navy at Pearl
Harbor, and Weyerhaeuser to name but a few and presented
on Streams and Change Data Capture at UKOUG in 2006.
Dan Morgan is the Morgan behind the "Morgan's
Library" website that contains the many demos he has
created for his University of Washington classes as well
as for his frequent lectures. He is the former publisher
of MacTech Journal, has presented Oracle technical
lectures in the US, Canada, Great Britain, and Japan.
Morgan is also the author of this course.
|
|
