White Papers

Oracle Database 10g: Top Features for DBAs - Part 4: Data Warehousing and Integration Features

Overview This paper presents new features for more efficiently managing materialized views, Query Rewrite, Transportable Tablespace, and table partitions make the data warehouse an even more powerful, and less resource-intensive, asset. The paper presents Data Warehousing and Integration features of Oracle Database 10g such as Partition Change-Tracking Without MV Logs, Query Rewrite with Multiple MVs, Transportable Tablespace From Backup, Quick Partition Split for Partitioned Index-Organized Tables, LONG to LOB Conversion via Online Redef, Online Reorg of a Single Partition, and Partition-by-Partition Table Drop.

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher: Oracle
File Format: HTML
Date Published: Oct 11, 2006
Format: White Papers
Topics: Database Applications, Business Intelligence - Data Warehousing, Database Management

Similiar White Papers

The Definition of a Business Service for Customer Data Integration

With the rapid growth in interest in customer data integration (CDI) applications and service oriented architectures (SO

Publisher: IBM | Tags: applications, crm, data, data integration

Bust a Move with Your SSIS - Passing Package Variables

Integration Services (SSIS), the next generation of the Extract, Transport, and Load (ETL) feature included with Microso

Publisher: Global Knowledge | Tags: data

Grameenphone Deploys Data Warehouse to Store and Manage Millions of Records

Grameenphone Ltd. wanted to consolidate disparate data formats into a single data warehouse and leverage the data to bet

Publisher: Oracle | Tags: business intelligence, data, data loss, data warehouse, management, warehouse

The Great Debate: Buy Versus Build -- Oracle's Pre-built Analytic Applications Versus Building a Custom Warehouse

In the past, pre-built analytic applications have nearly all have failed to deliver, as vendors have often left data war

Publisher: Oracle | Tags: applications, business intelligence, data, data warehouse, tco, warehouse

Advances in Data Warehouse Performance: I/O Elimination in DB2

WinterCorp analyzes IBM's DB2 Warehouse and how it addresses twin challenges facing enterprises today: improving the val

Publisher: IBM | Tags: data, real time data, warehouse

Oracle White Papers

Featured white papers

The Value of Location Intelligence in the Communications Industry

Pitney Bowes

Public Services are under pressure, the challenge is to do more with less. How do you improve citizen satisfaction, increase cost efficiencies and improve service delivery? The power of location intelligence is helping many local authorities...

Download now »
Best Practices for Translating Customer Satisfaction into Revenue

Citrix Online

Today's support organisations are focused on two top-level metrics: financial results and customer satisfaction. For most, it's easy to track financial performance, but customer satisfaction is akin to speaking a foreign language...

Download now »
HP print solutions and 3M

Hewlett-Packard (HP)

The objective for 3M was to optimize office printing infrastructure at 3M locations worldwide, reduce total cost and environmental footprint. Some of the business benefits acheived by switching to HP print solutions...

Download now »