You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for data mart


1 to 60 of 32681 results. Previous page Prev  Next next page
Results per page:  20 | 40 |  60 


Database Data Warehousing Guide, 11g Release 2 (11.2)

Glossary

data martfinance. In a dependent data mart, the data can be derived from an enterprise-wide data warehouse. In … an independent data mart, data can be collected directly from sources. … A data warehouse that is designed for a particular line of business, such

Database Data Warehousing Guide, 11g Release 2 (11.2)

Transportation in Data Warehouses

Transportable Tablespaces Example Suppose that you have a data warehouse containing sales data, and…example, the tablespace ts_temp_sales could contain multiple tables. For example, perhaps the data mart … The current month's data must be placed into a separate tablespace in order to be transported. In … this example, you have a tablespace ts_temp_sales, which holds a copy of the current month's data … . Using

Database Data Warehousing Guide, 11g Release 2 (11.2)

Transportation in Data Warehouses

Step 3   Copy the Datafiles and Export File to the Target Systemdata mart platform, using any transportation mechanism for flat files. Once the datafiles have been … Copy the data files that make up ts_temp_sales, as well as the export file jan_sales.dmp to the

Database Data Warehousing Guide, 11g Release 2 (11.2)

Transportation in Data Warehouses

Step 4   Import the MetadataOnce the files have been copied to the data mart, the metadata should be imported into the datamart. You can incorporate this new data into the data mart's tables. You can insert the data from … a permanent part of the data mart.

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Loading Data into Data WarehousesA popular and efficient way to load data into a data warehouse or data mart is to use SQL*Loader … with the DIRECT or PARALLEL option, Data Pump, or to use another loader tool that uses the Oracle … -phase. In one-phase loading, data is loaded directly into the target table, quality

Database Data Warehousing Guide, 11g Release 2 (11.2)

Transportation in Data Warehouses

Overview of Transportation in Data Warehousesdata warehouse to a data mart Transportation is often one of the simpler portions of the ETL process … Transportation is the operation of moving data from one system to another system. In a data … warehouse environment, the most common requirements for transportation are in moving data

Warehouse Builder Data Modeling ETL, and Data Quality Guide,, 11g Release 2 (11.2)

Creating Relational Data Objects

2 Creating Relational Data ObjectsAfter you finish designing your data warehouse or data mart, you are ready to design your target … system. This chapter shows you how to create relational data objects.

Database Data Warehousing Guide, 11g Release 2 (11.2)

Hardware and I/O Considerations in Data Warehouses

Configure I/O for Bandwidth not Capacity, consider a 200GB data mart. Using 72GB drives, this data mart could be built with as few as six drives … Storage configurations for a data warehouse should be chosen based on the I/O bandwidth that they … data, but cannot provide the same I/O throughput as a larger number of small

Database Data Warehousing Guide, 11g Release 2 (11.2)

Database Data Warehousing Guide - Contents

ContentsConventions What's New in Oracle Database? Oracle Database 11g Release 2 (11.2) New Features in Data … Warehousing Oracle Database 11g Release 1 (11.1) New Features in Data Warehousing Part I Concepts 1 … Data Warehousing Concepts What is a Data Warehouse? Subject Oriented Integrated Nonvolatile Time … Variant

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Overview of Materialized View Management Taskslonger useful. After the initial effort of creating and populating the data warehouse or data mart, the … materialized views should be dropped. Archiving old detail and materialized view data that is no … incremental changes from the operational systems. Transforming the data. Verifying that the incremental

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Materialized Views

Rolling Materialized Viewsdata mart contains a time dimension, it is often desirable to archive the oldest information and … and then repopulate the partition with new data. Oracle Database uses this variant of fast refresh … or list partitioned. PCT refresh is nonatomic. Rolling Materialized Views When a data warehouse or … maintenance

Database Data Warehousing Guide, 11g Release 2 (11.2)

Transportation in Data Warehouses

Transportation Using Transportable Tablespacesa staging database to a data warehouse, or in moving data from a data warehouse to a data mart. … Oracle transportable tablespaces are the fastest way for moving large volumes of data between two … Oracle databases. Previous to the introduction of transportable tablespaces, the most

Database Data Warehousing Guide, 11g Release 2 (11.2)

Extraction in Data Warehouses

Extraction Through Distributed Operationstable in a data mart, country_city, and populates it with data from the countries and customers tables … Extracting into Flat Files Using SQL*Plus The most basic technique for extracting data is to … customized format. Note that, using the external table data pump unload facility, you can also extract

Database Data Warehousing Guide, 11g Release 2 (11.2)

Glossary

subject areaknowledge. A data mart is often developed to support a subject area such as sales, marketing, or geography.

Warehouse Builder Data Modeling ETL, and Data Quality Guide,, 11g Release 2 (11.2)

Moving Large Volumes of Data Using Transportable Modules

Benefits of Using Transportable Modulestransportable modules to copy from a read-only data mart to multiple departmental databases. In this way, you … takes relatively less time, you can publish and distribute a data mart for daily analytical or … Before the introduction of transportable modules, the most scalable data transportation method

Database Data Warehousing Guide, 11g Release 2 (11.2)

Glossary

third normal form schemasignificant data loading requirements that is used to feed a data mart and execute long-running queries. Compare with snowflake schema and star schema. … normal form schemas are sometimes chosen for a large data warehouse, especially an environment with

Communications Data Model Reference, 11g Release 2 (11.2)

Communications Data Model Reference - Contents

ContentsConventions Part I Logical and Physical Data Model 1 Introducing Oracle Communications Data Model … Overview of Oracle Communications Data Model What Are the Benefits of Using Oracle Communications Data … Model? What Are the Components of Oracle Communications Data Model? What Oracle Technologies are

Retail Data Model Reference, 11g Release 2 (11.2)

Retail Data Model Reference - Contents

ContentsAccessibility Related Documents Conventions 1 Introducing Oracle Retail Data Model What is Oracle Retail … Data Model? New Features in Oracle Retail Data Model What Are the Components of Oracle Retail Data … Model Oracle Products That Make Up Oracle Retail Data Model Part I Logical and Physical Data

Data Mining Administrator's Guide, 11g Release 2 (11.2)

Data Mining Administrator's Guide - Contents

ContentsConventions What's New in Oracle Data Mining Administration? Oracle Database 11 g Release 2 (11.2.0.3 … ) Oracle Data Mining Oracle Database 11 g Release 2 (11.2.0.2) New Features in Oracle Data Mining Oracle … Database 11g Release 1 New Features in Oracle Data Mining 1 Getting Started with Oracle Data

Airlines Data Model Reference, 11g Release 2 (11.2)

Airlines Data Model Reference - Contents

ContentsConventions Part I Logical and Physical Data Model 1 Introducing Oracle Airlines Data Model What is … Oracle Airlines Data Model? What Are the Benefits of Using Oracle Airlines Data Model? What Are the … Components of Oracle Airlines Data Model? Oracle Products That Make Up Oracle Airlines Data

Data Mining Concepts, 11g Release 2 (11.2)

Data Mining Concepts - Contents

ContentsDocumentation Accessibility Related Documentation Conventions What's New in Oracle Data Mining? Oracle … Database 11 g Release 2 (11.2.0.3) Oracle Data Mining Oracle Database 11 g Release 2 (11.2.0.2 … ) Oracle Data Mining Oracle Database 11 g Release 1 (11.1) Oracle Data Mining Part I Introductions 1 What … Is

Data Guard Broker, 11g Release 2 (11.2)

Data Guard Broker - Contents

ContentsDocumentation Accessibility Related Documents Conventions What's New in Oracle Data Guard Broker? New … Features in Oracle Data Guard Broker 11.2.0.4 New Features in Oracle Data Guard Broker 11.2.0.3 New … Features in Oracle Data Guard Broker 11.2 New Features in Oracle Data Guard Broker 11.1 1 Oracle

Warehouse Builder Data Modeling ETL, and Data Quality Guide,, 11g Release 2 (11.2)

Moving Large Volumes of Data Using Transportable Modules

About Transportable Modulesthe data warehouse. Transportable modules can also be used for publishing data marts. A data mart is … a data mart amounts to copying what has been collected and processed in the data warehouse. A … to deploy a data mart to multiple

Warehouse Builder Data Modeling ETL, and Data Quality Guide,, 11g Release 2 (11.2)

Warehouse Builder Data Modeling, ETL, and Data Quality Guide - Contents

ContentsHelp Related Documents Part I Data Modeling 1 Designing Source and Target Schemas Designing Target … Schemas Configuring Data Objects Validating Data Objects Viewing Validation Results Editing Invalid … Objects Generating Data Objects Viewing Generation Results and Generated Scripts Saving Generated Scripts

Airlines Data Model Installation Guide, 11g Release 2 (11.2)

Airlines Data Model Installation Guide - Contents

ContentsIntroduction to Oracle Airlines Data Model Installation Types of Installations Provided for Oracle … Airlines Data Model Overview of the Installation Process 3 Installation of Oracle Airlines Data Model Pre … -installation Tasks Ensuring that Required Software is Installed Confirming that Oracle Data Mining

Communications Data Model Installation Guide, 11g Release 2 (11.2)

Communications Data Model Installation Guide - Contents

ContentsData Integrator Enterprise Edition Oracle GoldenGate 2 Introduction to Oracle Communications Data … Model Installation Types of Installations Provided for Oracle Communications Data Model Overview of the … Installation Process 3 Installation of Oracle Communications Data Model Preinstallation Tasks … Ensuring

Data Mining Application Developer's Guide, 11g Release 2 (11.2)

Data Mining Application Developer's Guide - Contents

ContentsDocumentation Accessibility Related Documentation Conventions What's New in the Oracle Data Mining … APIs? Oracle Data Mining 11 g Release 2 (11.2.0.3) API New Features Oracle Data Mining 11 g Release 2 … (11.2.0.1) API New Features 1 Data Mining API Use Cases Analyze Customer Demographics and Buying … Customer

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Data Guard Concepts and Administration - Contents

ContentsDocumentation Accessibility Related Documents Conventions What's New in Oracle Data Guard? Oracle … Database 11g Release 2 (11.2.0.3) New Features in Oracle Data Guard New Features in Oracle Data Guard … 11.2 New Features in Oracle Data Guard 11.1 Part I Concepts and Administration 1 Introduction to … Oracle Data

Retail Data Model Installation Guide, 11g Release 2 (11.2)

Retail Data Model Installation Guide - Contents

ContentsPlatform Requirements: Database and Configuration Parameters 2 Introduction to Oracle Retail Data Model … Installation Types of Installations Provided for Oracle Retail Data Model Retail Data Model … Installation Sample Reports Installation Oracle Retail Data Model Home Directory Structure Overview of the … Installation

Data Provider for .NET Developer's Guide, 11g Release 2 (11.2)

Data Provider for .NET Developer's Guide - Contents

ContentsPasswords in Code Examples Conventions What's New in Oracle Data Provider for.NET? New Features in … Oracle Data Provider for.NET Release 11.2.0.3 New Features in Oracle Data Provider for.NET Release … 11.2.0.2 New Features in Oracle Data Provider for.NET Release 11.2.0.1.2 New Features in Oracle Data

Airlines Data Model Implementation and Operations Guide, 11g Release 2 (11.2)

Airlines Data Model Implementation and Operations Guide - Contents

ContentsAccessibility Related Oracle Resources Conventions 1 Introduction to Oracle Airlines Data Model … Customization What is the Oracle Airlines Data Model? Components of the Oracle Airlines Data Model Oracle … Products That Make Up Oracle Airlines Data Model Steps for Implementing an Oracle Airlines Data

Communications Data Model Implementation and Operations Guide, 11g Release 2 (11.2)

Communications Data Model Implementation and Operations Guide - Contents

ContentsAccessibility Related Oracle Resources Conventions 1 Introduction to Oracle Communications Data Model … Customization What is the Oracle Communications Data Model? Components of Oracle Communications Data … Model Oracle Products That Make Up Oracle Communications Data Model Steps for Implementing an Oracle … Communications

Retail Data Model Implementation and Operations Guide, 11g Release 2 (11.2)

Retail Data Model Implementation and Operations Guide - Contents

ContentsAccessibility Related Oracle Resources Conventions 1 Introduction to Oracle Retail Data Model … Customization What is the Oracle Retail Data Model? Components of the Oracle Retail Data Model Oracle … Products That Make Up Oracle Retail Data Model Steps for Implementing an Oracle Retail Data Model Warehouse

Spatial Topology and Network Data Models Developer's Guide, 11g Release 2 (11.2)

Spatial Topology and Network Data Models Developer's Guide - Contents

ContentsDocumentation Accessibility Related Documents Conventions What's New in the Topology and Network Data … Models? Release 11.2 Changes Release 11.1 Changes Part I Topology Data Model 1 Topology Data Model … Overview 1.1 Main Steps in Using Topology Data 1.1.1 Using a Topology Built from Topology Data 1.1.2

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle ASM Disk Groups

Intelligent Data Placementsettings, you can ensure that frequently accessed data is placed on the outermost (hot) tracks … located physically close, reducing latency. Intelligent Data Placement also enables the placement of … primary and mirror extents into different hot or cold regions. Intelligent Data Placement settings can … frequently accessed data

Database Administrator's Guide, 11g Release 2 (11.2)

Getting Started with Database Administration

Data UtilitiesOracle utilities are available to help you maintain the data in your Oracle Database. SQL*Loader … data from standard operating system files (such as, files in text or C data format) into database … tables. Export and Import Utilities The Data Pump utility enables you to archive data and to move data

Database SQL Language Reference, 11g Release 2 (11.2)

Data Types

Data TypesEach value manipulated by Oracle Database has a data type. The data type of a value associates a … fixed set of properties with the value. These properties cause Oracle to treat values of one data type … differently from values of another. For example, you can add values of NUMBER data type, but not … values of

Database PL/SQL Language Reference, 11g Release 2 (11.2)

Overview of PL/SQL

Data AbstractionData abstraction lets you work with the essential properties of data without being too involved … with details. You can design a data structure first, and then design algorithms that manipulate it … . Topics Cursors Composite Variables %ROWTYPE Attribute %TYPE Attribute Abstract Data Types Cursors A … always of

Database SQL Language Reference, 11g Release 2 (11.2)

Data Type Comparison Rules

Data ConversionGenerally an expression cannot contain values of different data types. For example, an expression … cannot multiply 5 by 10 and then add 'JAMES'. However, Oracle supports both implicit and explicit conversion of values from one data type to another.

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Data Files and Temp Files

Data Files Data Dictionary ViewsThe following data dictionary views provide useful information about the data files of a database … : View Description DBA_DATA_FILES Provides descriptive information about each data file, including the … segments in the database. Contains the file ID of the data file containing the extent. USER view describes

Database Licensing Information, 11g Release 2 (11.2)

Options and Packs

Oracle Partitioningenhances the data management environment for OLTP, data mart, data warehouse, and content … individually managed smaller pieces, while retaining a single application-level view of the data. The

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Data Files and Temp Files

Verifying Data Blocks in Data FilesTo configure the database to use checksums to verify data blocks, set the initialization parameter … the setting of this parameter, checksums are always used to verify data blocks in the SYSTEM

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Performing Oracle ASM Data Migration with RMAN

Purpose of Oracle ASM Data MigrationOracle ASM storage. Because RMAN can read and write Oracle ASM files, you can use RMAN to copy data

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Performing Oracle ASM Data Migration with RMAN

Basic Concepts of Oracle ASM Data MigrationYou can migrate data to Oracle ASM with RMAN even if you are not using RMAN as your primary backup

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Performing Oracle ASM Data Migration with RMAN

Overview of Oracle ASM Data MigrationThis section explains the basic concepts and tasks involved in migrating data to and from Oracle … ASM. This section includes the following topics: Purpose of Oracle ASM Data Migration Basic Concepts … of Oracle ASM Data Migration Basics Steps of Data Migration to Oracle ASM Using RMAN

Database SQL Language Reference, 11g Release 2 (11.2)

Data Types

NCLOB Data TypeThe NCLOB data type stores Unicode data. Both fixed-width and variable-width character sets are … ) * (the value of the CHUNK parameter of LOB storage) of character text data. If the tablespaces in your … and then use it in another transaction or session. See Also: Oracle Database Globalization Support Guide for information on Unicode

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Clusters

Clusters Data Dictionary ViewsThe following views display information about clusters: View Description DBA_CLUSTERS ALL_CLUSTERS USER_CLUSTERS DBA view describes all clusters in the database. ALL view describes all clusters accessible to the user. USER view is restricted to clusters owned by the user. Some columns in these views contain statistics that are generated by the DBMS_STATS package or ANALYZE statement. DBA_CLU_COLUMNS

Database SQL Language Reference, 11g Release 2 (11.2)

Data Cartridge Functions

Data Cartridge FunctionsData Cartridge functions are useful for Data Cartridge developers. The Data Cartridge function is: DATAOBJ_TO_PARTITION Press \"Next\" to go to the first SQL function.

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Data Files and Temp Files

Place Data Files AppropriatelyTablespace location is determined by the physical location of the data files that constitute that … drives are available to store the database, consider placing potentially contending data files on … , retrieving data at the same time. See Also: Oracle Database Performance Tuning Guide for information about I/O and the placement of data

Database SQL Language Reference, 11g Release 2 (11.2)

Data Types

NCHAR Data TypeThe NCHAR data type is a Unicode-only data type. When you create a table with an NCHAR column, you … . Width specifications of character data type NCHAR refer to the number of characters. The maximum column … : Oracle Database Globalization Support Guide for information on Unicode data type support

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Data Files and Temp Files

Dropping Data Filessingle data file or temp file. The data file must be empty. (A data file is considered to be empty when … no extents remain allocated from it.) When you drop a data file or temp file, references to the data … file or temp file are removed from the data dictionary and control files, and

Database SQL Language Reference, 11g Release 2 (11.2)

Data Type Comparison Rules

Implicit Data Conversion ExamplesText Literal Example  The text literal '10' has data type CHAR. Oracle implicitly converts it to … the NUMBER data type if it appears in a numeric expression as in the following statement: SELECT

Database SQL Language Reference, 11g Release 2 (11.2)

Data Types

BFILE Data TypeThe BFILE data type enables access to binary file LOBs that are stored in file systems outside … provides file integrity and durability. BFILE data can be up to 2 64 -1 bytes, although your operating … BFILE data type enables read-only support of large binary files. You cannot modify or replicate such a … file. Oracle provides

Database SQL Language Reference, 11g Release 2 (11.2)

Data Type Comparison Rules

Explicit Data ConversionYou can explicitly specify data type conversions using SQL conversion functions. Table 3-12 shows … SQL functions that explicitly convert a value from one data type to another. You cannot specify LONG … and LONG RAW values in cases in which Oracle can perform implicit data type conversion. For example … Data Type\"

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Data Files and Temp Files

Altering Data File AvailabilityYou can alter the availability of individual data files or temp files by taking them offline or … bringing them online. Offline data files are unavailable to the database and cannot be accessed until … they are brought back online. Reasons for altering data file availability include the following: You … want to perform an offline

Database SQL Language Reference, 11g Release 2 (11.2)

Data Type Comparison Rules

Data Type Comparison RulesThis section describes how Oracle Database compares values of each data type.

Database Administrator's Guide, 11g Release 2 (11.2)

Repairing Corrupted Data

25 Repairing Corrupted DataIn this chapter: Options for Repairing Data Block Corruption About the DBMS_REPAIR Package Using

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Collections and Records

Data Type CompatibilityYou can assign a collection to a collection variable only if they have the same data type. Having … element type, VARCHAR(15). Collection variables group1 and group2 have the same data type, triplet, but … collection variable group3 has the data type trio. The assignment of group1 to group2 succeeds, but … the assignment of group1

Database SQL Language Reference, 11g Release 2 (11.2)

Data Types

CHAR Data TypeThe CHAR data type specifies a fixed-length character string. Oracle ensures that all values stored … override the parameter. To ensure proper data conversion between databases with different character sets … , you must ensure that CHAR data consists of well-formed strings. See Also: Oracle Database … Globalization Support Guide

Database SQL Language Reference, 11g Release 2 (11.2)

Manual Data Locking

Manual Data LockingOracle Database always performs locking automatically to ensure data concurrency, data integrity … data for the duration of the transaction, not reflecting changes by other transactions, you can … transactions to complete, you can explicitly lock the data for the duration of the transaction. You can … developer