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 2041 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Concepts, 11g Release 2 (11.2)

Partitions, Views, and Other Schema Objects

Partition CharacteristicsEach partition of a table or index must have the same logical attributes, such as column names … partition can have separate physical attributes, such as the tablespace to which it belongs. Partition Key … The partition key is a set of one or more columns that determines the partition in which each row

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

Glossary

partition… To an application, a partition appears as an independent disk, even though that is not the case. The … . This command writes a partition map onto the disk in an area that is not visible to the application program.

Database Concepts, 11g Release 2 (11.2)

Glossary

partitionA piece of a table or index that shares the same logical attributes as the other partitions. For example, all partitions in a table share the same column and constraint definitions.

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

Managing Tables

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 2 (11.2)

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 parallelize … a build using multiwriter. Note: Because the AGGREGATE command does not consider partition … a single AGGREGATE command. partition-name

OLAP DML Reference, 11g Release 2 (11.2)

PARTITION

PARTITIONThe PARTITION function returns the name of the partition in which a value is stored. Return Value … Text Syntax PARTITION ( partition_template_values ) Parameters

OLAP DML Reference, 11g Release 2 (11.2)

PARTITION

partition_template_valuesAn expression that represents one or more values of the partition template (for example, the name … of a partition template or a QDR). Examples Example 8-60 Retrieving the Name of a Partition Assume … DEFINE time_parentrel RELATION time DEFINE partition_sales_by_year PARTITION TEMPLATE - PARTITION

Database Performance Tuning Guide, 11g Release 2 (11.2)

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 … Partition-Wise Join with Range Partition CREATE TABLE dept2 AS SELECT * FROM departments; ALTER TABLE … dept2 PARALLEL 2; CREATE TABLE emp_range_did PARTITION BY RANGE(department_id) (PARTITION emp_p1

Database Performance Tuning Guide, 11g Release 2 (11.2)

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 Concepts, 11g Release 2 (11.2)

Glossary

partition keyA set of one or more columns that determines the partition in which each row in a partitioned table … should go. Each row is unambiguously assigned to a single partition.

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

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 2 (11.2)

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 2 (11.2)

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 Data Warehousing Guide, 11g Release 2 (11.2)

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 … PARTITION

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

Advanced Query Rewrite

Partition Change Tracking (PCT) Rewritemv.promo_name IN ('coupon', 'premium'); Partition Change Tracking (PCT) Rewrite PCT rewrite enables the … , DBA_DETAIL_RELATIONS, and DBA_MVIEW_DETAIL_PARTITION views. See \"Viewing Partition Freshness\" for

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

PL/SQL Static SQL

Creating Cursor Variablestype). Note: You can partition weak cursor variable arguments to table functions only with the … PARTITION BY ANY clause, not with PARTITION BY RANGE or PARTITION BY HASH. For syntax and semantics, see

Warehouse Builder OMB*Plus Command Reference, 11g Release 2 (11.2)

OMBALTER MATERIALIZED_VIEW

PARTITION ObjectTable 3-56 PARTITION Object Property Type Choices Min Max Default Description BUFFER_POOL STRING … partition object. The default is DEFAULT. DATA_SEGMENT_COMPRESSION STRING, COMPRESS, COMPRESS ALL … string Specify the number of free lists for each of the free list groups for the table, partition … indexes required because of constraints,

Warehouse Builder OMB*Plus Command Reference, 11g Release 2 (11.2)

OMBCREATE TABLE

PARTITION ObjectTable 9-105 PARTITION Object Property Type Choices Min Max Default Description BUFFER_POOL STRING … partition object. The default is DEFAULT. DATA_SEGMENT_COMPRESSION STRING, COMPRESS, COMPRESS ALL … string Specify the number of free lists for each of the free list groups for the table, partition … indexes required because of

OLAP DML Reference, 11g Release 2 (11.2)

PARTITIONCHECK

partition-templateA text expression that is the name of the partition template object to check for compatibility with aggregation.

OLAP DML Reference, 11g Release 2 (11.2)

MAINTAIN

partition-templateA text expression that is the name of a previously-defined partition template object. MOVE TO … PARTITION Specifies that values are to be added to the partition or moved from one partition to another … . partition A text expression that is the name of a previously-defined partition in