How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
data mart → finance. 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
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
Step 3 Copy the Datafiles and Export File to the Target System → data 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
Step 4 Import the Metadata → Once the files have been copied to the data mart, the metadata should be imported into the data … mart. 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.
Loading Data into Data Warehouses → A 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
Overview of Transportation in Data Warehouses → data 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
2 Creating Relational Data Objects → After 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.
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
Contents → Conventions 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
Overview of Materialized View Management Tasks → longer 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
Rolling Materialized Views → data 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
Transportation Using Transportable Tablespaces → a 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
Extraction Through Distributed Operations → table 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
subject area → knowledge. A data mart is often developed to support a subject area such as sales, marketing, or geography.
Benefits of Using Transportable Modules → transportable 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
third normal form schema → significant 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
Contents → Conventions 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
Contents → Accessibility 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
Contents → Conventions What's New in Oracle Data Mining Administration? Oracle Database 11 g Release 2 (18.104.22.168 … ) Oracle Data Mining Oracle Database 11 g Release 2 (22.214.171.124) New Features in Oracle Data Mining Oracle … Database 11g Release 1 New Features in Oracle Data Mining 1 Getting Started with Oracle Data
Contents → Conventions 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
Contents → Documentation Accessibility Related Documentation Conventions What's New in Oracle Data Mining? Oracle … Database 11 g Release 2 (126.96.36.199) Oracle Data Mining Oracle Database 11 g Release 2 (188.8.131.52 … ) Oracle Data Mining Oracle Database 11 g Release 1 (11.1) Oracle Data Mining Part I Introductions 1 What … Is
Contents → Documentation Accessibility Related Documents Conventions What's New in Oracle Data Guard Broker? New … Features in Oracle Data Guard Broker 184.108.40.206 New Features in Oracle Data Guard Broker 220.127.116.11 New … Features in Oracle Data Guard Broker 11.2 New Features in Oracle Data Guard Broker 11.1 1 Oracle
About Transportable Modules → the 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
Contents → Help 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
Contents → Introduction 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
Contents → Data 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
Contents → Documentation Accessibility Related Documentation Conventions What's New in the Oracle Data Mining … APIs? Oracle Data Mining 11 g Release 2 (18.104.22.168) API New Features Oracle Data Mining 11 g Release 2 … (22.214.171.124) API New Features 1 Data Mining API Use Cases Analyze Customer Demographics and Buying … Customer
Contents → Documentation Accessibility Related Documents Conventions What's New in Oracle Data Guard? Oracle … Database 11g Release 2 (126.96.36.199) 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
Contents → Platform 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
Contents → Passwords in Code Examples Conventions What's New in Oracle Data Provider for.NET? New Features in … Oracle Data Provider for.NET Release 188.8.131.52 New Features in Oracle Data Provider for.NET Release … 184.108.40.206 New Features in Oracle Data Provider for.NET Release 220.127.116.11.2 New Features in Oracle Data
Contents → Accessibility 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
Contents → Accessibility 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
Contents → Accessibility 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
Contents → Documentation 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
Intelligent Data Placement → settings, 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
Data Utilities → Oracle 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
Data Types → Each 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
Data Abstraction → Data 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
Data Conversion → Generally 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.
Data Files Data Dictionary Views → The 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
Oracle Partitioning → enhances 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
Verifying Data Blocks in Data Files → To 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
Purpose of Oracle ASM Data Migration → Oracle ASM storage. Because RMAN can read and write Oracle ASM files, you can use RMAN to copy data
Basic Concepts of Oracle ASM Data Migration → You can migrate data to Oracle ASM with RMAN even if you are not using RMAN as your primary backup
Overview of Oracle ASM Data Migration → This 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
NCLOB Data Type → The 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
Clusters Data Dictionary Views → The 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
Data Cartridge Functions → Data 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.
Place Data Files Appropriately → Tablespace 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
NCHAR Data Type → The 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
Dropping Data Files → single 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
Implicit Data Conversion Examples → Text 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
BFILE Data Type → The 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
Explicit Data Conversion → You 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\"
Altering Data File Availability → You 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
Data Type Comparison Rules → This section describes how Oracle Database compares values of each data type.
25 Repairing Corrupted Data → In this chapter: Options for Repairing Data Block Corruption About the DBMS_REPAIR Package Using
Data Type Compatibility → You 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
CHAR Data Type → The 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
Manual Data Locking → Oracle 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