Lesser known options for upgrading Oracle Server or migrating an existing Database to new hardware. Most of the features covered in this session will be specific to a particular version or edition of Oracle but don't necessarily require an additonal license. Oracle's specific recommendations on reducing downtime for each type of migration path will be…

Lesser known options for upgrading Oracle Server or migrating an existing Database to new hardware. Most of the features covered in this session will be specific to a particular version or edition of Oracle but don't necessarily require an additonal license. Oracle's specific recommendations on reducing downtime for each type of migration path will be…

There are several components integrated into Oracle Database that make it highly available. While Oracle advertises major improvements there are features that have been integrated but not marketed as part of the Maximum Availability Architecture. Flashback Technologies have all been grouped together with a common name but actually operate utilizing several mechanisms as part of…

A A successful real-time data warehouse implementation involves integrating the logical and physical model, source and target databases, ETL subsystems, and front-end dashboards and reports. In this session, we will explore how these different pieces fit together, demonstrated using the Oracle Database (including Warehouse Builder) and Oracle Business Intelligence Enterprise Edition. We will investigate alternative…

There are many code debugging tools available to Oracle developers. Some require more effort than others. The author will walk the audience through a debugging session using SQL Developer and how it's used with XML Documents. Focus on Oracle Database 11g R2

There are many code debugging tools available to Oracle developers. Some require more effort than others. The author will walk the audience through a debugging session using SQL Developer and how it's used with XML Documents. Focus on Oracle Database 11g R2

Declarative constraints are designed to implement simple business rules to ensure data integrity. But constraints are much more versatile having roles in query optimization and transformation. When used with materialized views complex business rules can be implemented thus avoiding the need for database triggers. Constraints can be deferred and not enforced on existing data. This…

Declarative constraints are designed to implement simple business rules to ensure data integrity. But constraints are much more versatile having roles in query optimization and transformation. When used with materialized views complex business rules can be implemented thus avoiding the need for database triggers. Constraints can be deferred and not enforced on existing data. This…

Declarative constraints are designed to implement simple business rules to ensure data integrity. But constraints are much more versatile having roles in query optimization and transformation. When used with materialized views complex business rules can be implemented thus avoiding the need for database triggers. Constraints can be deferred and not enforced on existing data. This…

Declarative constraints are designed to implement simple business rules to ensure data integrity. But constraints are much more versatile having roles in query optimization and transformation. When used with materialized views complex business rules can be implemented thus avoiding the need for database triggers. Constraints can be deferred and not enforced on existing data. This…