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 partition


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


Database Concepts, 11g Release 1 (11.1)

Very Large Databases (VLDB)

Partition Pruning) unnecessary partitions or subpartitions from access by those SQL statements. In other words, partition … rows in the accessed partition or subpartition, it removes those criteria from the predicate list … partition pruning with range or list partitioning, and equality and IN -list predicates are considered for … partition

Database Concepts, 11g Release 1 (11.1)

Very Large Databases (VLDB)

Partition KeyEach row in a partitioned table is unambiguously assigned to a single partition. The partition key … is a set of one or more columns that determines the partition for each row. Oracle Database … automatically directs insert, update, and delete operations to the appropriate partition through the use of … the partition

Database Concepts, 11g Release 1 (11.1)

Very Large Databases (VLDB)

Partition-wise JoinsA partition-wise join is a join optimization for joining two tables that are both partitioned along … the join column(s). With partition-wise joins, the join operation is broken into smaller joins that … are performed sequentially or in parallel. Another way of looking at partition-wise joins is that … for more information about

Database Concepts, 11g Release 1 (11.1)

Glossary

partitionone partition for every calendar quarter. For large tables, partitions improve query performance and make table administration easier.

Database Administrator's Guide, 11g Release 1 (11.1)

Redefining Tables Online

Online Redefinition of a Single PartitionOnline Rede finition of a Single Partition Beginning with Oracle Database 10g Release 2, you can … redefine online a single partition of a table. This is useful if, for example, you want to move a … partition to a different tablespace and keep the partition available for DML during the operation … . Another use

OLAP DML Reference, 11g Release 1 (11.1)

PARTITION

PARTITIONThe PARTITION function returns the name of the partition in which a value is stored. Return Value … Text Syntax PARTITION ( partition_template_name ) Examples Example 8-60 Retrieving the Names of … DIMENSION TEXT DEFINE time_parentrel RELATION time DEFINE partition_sales_by_year PARTITION … TEMPLATE - PARTITION

OLAP DML Reference, 11g Release 1 (11.1)

AGGREGATE command

PARTITIONSpecifies that you want AGGREGATE to recalculate only the values in the specified partition of the … specified variable. Frequently, the reason for aggregating only a single partition is to parallize a … build using multiwriter. Note: Since the AGGREGATE command does not consider partition dependencies … within a single AGGREGATE

Database Administrator's Guide, 11g Release 1 (11.1)

Redefining Tables Online

Rules for Online Redefinition of a Single PartitionRules for Online Rede finition of a Single Partition The underlying mechanism for redefinition of a … single partition is the exchange partition capability of the database ( ALTER TABLE... EXCHANGE … PARTITION ). Rules and restrictions for online redefinition of a single partition are therefore

Database Performance Tuning Guide, 11g Release 1 (11.1)

Using EXPLAIN PLAN

12.9.3 Examples of Partial Partition-wise Joinsparallelized. This enables use of partial partition-wise join, because the dept2 table is not … partitioned. Oracle dynamically partitions the dept2 table before the join. Example 12-10 Partial Partition … -Wise Join with Range Partition CREATE TABLE dept2 AS SELECT * FROM departments; ALTER TABLE dept2 … PARALLEL 2; CREATE TABLE

Database Performance Tuning Guide, 11g Release 1 (11.1)

Using EXPLAIN PLAN

12.9.4 Examples of Full Partition-wise Joins… This enables use of full partition-wise join. The PARTITION HASH row source appears on top of the join … row source in the plan table output. The PX PARTITION HASH row source appears on top of the join row … source in the plan table output while the PX PARTITION RANGE row source appears over the scan of

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

Partition Name Pmarkersales_par_list WHERE country_name = 'India'; You have deleted rows from partition Asia in table … in terms of sales_per_dt_partition_mv as all the data corresponding to a detail table partition is … in partition America, which has not been updated. The query is rewritten in terms of … Rowid as PMARKER A materialized view supports

Database Data Warehousing Guide, 11g Release 1 (11.1)

SQL for Analysis and Reporting

Partition Join SyntaxThe syntax for partitioned outer join extends the ANSI SQL JOIN clause with the phrase PARTITION BY … : SELECT..... FROM table_reference PARTITION BY (expr [, expr ]... ) RIGHT OUTER JOIN table_reference … SELECT..... FROM table_reference LEFT OUTER JOIN table_reference PARTITION BY {expr [,expr

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Materialized Views

Partition Change Trackingpartition, is known as Partition Change Tracking. When one or more of the detail tables are … modified detail partition(s); those rows become stale when a partition is modified while all other … particular partition. PCT is also used to support fast refresh after partition maintenance

Database Data Warehousing Guide, 11g Release 1 (11.1)

Glossary

partitionVery large tables and indexes can be difficult and time-consuming to work with. To improve manageability, you can break your tables and indexes into smaller pieces called partitions.

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Overview of PL/SQL

PL/SQL Blockspartition the block into a declarative part, an executable part, and an exception-handling part

Database Data Warehousing Guide, 11g Release 1 (11.1)

Maintaining the Data Warehouse

Partition Change Tracking (PCT) RefreshWhe n there have been some partition maintenance operations on the detail tables, this is the only … all the conditions described in \"Partition Change Tracking\" are satisfied. In the absence of … partition maintenance operations on detail tables, when you request a FAST method ( method => 'F' ) of … use TRUNCATE PARTITION

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

Partition Change Tracking (PCT) RewriteDBA_MVIEWS, DBA_DETAIL_RELATIONS, and DBA_MVIEW_DETAIL_PARTITION views. See \"Viewing Partition Freshness … example illustrates a PCT rewrite example where the materialized view is PCT enabled through partition … part_sales_by_time (time_id, prod_id, amount_sold, quantity_sold) PARTITION BY RANGE (time_id) ( PARTITION

Database PL/SQL Language Reference, 11g Release 1 (11.1)

PL/SQL Reserved Words and Keywords

D PL/SQL Reserved Words and Keywords, PARAMETERS, PARTITION, PASCAL, PIPE, PIPELINED, PRAGMA, PRECISION, PRIVATE R RAISE, RANGE, RAW

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Triggers

Event Attribute Functionsa PARTITION clause. -- Retrieve ora_sql_txt into -- sql_text variable first. v_n

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Tuning PL/SQL Applications for Performance

Passing Data with Cursor Variablesbe partitioned using the PARTITION BY ANY clause. You cannot use range or hash partitioning for weak