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


Reference, 9i Release 2 (9.2.0.2)

SQL Statements and Operators

PARTITION partnameRebuilds the index partition partname. Only one index partition can be built at a time. When you … rebuild a partition you can specify only sync, optimize full/fast, resume or replace in paramstring … partitions or a partitioned index. Adding Partitions To add a partition to the base table, use the … ALTER TABLE

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Parallelism and Partitioning in Data Warehouses

Partition GranulesWhen Oracle uses partition granules, a query server process works on an entire partition or … subpartition of a table or index. Because partition granules are statically determined by the structure of … the table or index when a table or index is created, partition granules do not give you the … execution servers.

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Parallelism and Partitioning in Data Warehouses

Partition PruningPartition pruning is an essential performance feature for data warehouses. In partition pruning … partitions when building the partition access list. This enables Oracle to perform operations only on … equality and IN -list predicates on the hash partitioning columns. Partition pruning dramatically … performance

Administrator's Guide, 9i Release 2 (9.2.0.2)

Storing Tablespaces on Raw Partitions

Logical PartitionA logical partition is a partition created by Disk Administrator that points to a drive other than … partition in a disk rather than the entire disk. Internally, these names can expand to: \\.\D:= \Device … : Oracle9 i database does not skip the first block of a logical raw partition used for an Oracle9 i datafile.

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 5 of 26

Partition ViewsPartition views were introduced in Oracle Release 7.3 to provide partitioning capabilities for … applications requiring them. Partition views are supported in Oracle9 i so that you can upgrade … you will want to migrate partition views into partitions. In Oracle9 i, you can use the CREATE TABLE … partition views,

Reference, 9i Release 2 (9.2.0.2)

SQL Statements and Operators

LOCAL [(PARTITION [ partition ] [PARAMETERS(' paramstring ')]specify the list of index partition names with partition. If you do not specify a partition name, the … system assigns one. The order of the index partition list must correspond to the table partition by … order. The PARAMETERS clause associated with each partition specifies the parameters

Migration, 9i Release 2 (9.2.0.2)

After Upgrading a Database

Migrate Partition Views to Partition TablesPartition views are not recommended for new applications in Oracle9 i, and existing partition views … should be converted to partitioned tables. You can convert partition views created for Oracle7 … databases to partitioned tables by using the EXCHANGE PARTITION option of the ALTER TABLE statement. See … partitioned

Administrator's Guide, 9i Release 2 (9.2.0.2)

Storing Tablespaces on Raw Partitions

Raw Partition Overviewraw partitions. A raw partition is a portion of a physical disk that is accessed at the lowest … possible level. Input/output (I/O) to a raw partition offers approximately a 5% to 10% performance … improvement over I/O to a partition with a file system on it. A raw partition is created after generation … of an

Reference, 9i Release 2 (9.2.0.2)

SQL Statements and Operators

Truncate Partition SyntaxALTER TABLE [schema.]table TRUNCATE PARTITION [DROP|REUSE STORAGE] Removes all rows from a … partition in a table. Corresponding CONTEXT index partitions are also removed.

Reference, 9i Release 2 (9.2.0.2)

SQL Statements and Operators

Modify Partition SyntaxUnusable Local Indexes ALTER TABLE [schema.]table MODIFY PARTITION partition UNUSABLE LOCAL INDEXES … Marks the index partition corresponding to the given table partition UNUSABLE. Rebuild Unusable … Local Indexes ALTER TABLE [schema.]table MODIFY PARTITION partition REBUILD UNUSABLE

Directory Service Integration and Deployment Guide, 9i Release 2 (9.2.0.2)

Planning and Deployment Guidelines

Reasons to PartitionPartitioning a directory over two or more servers is expensive because each partition must have its … partition corresponds to administrative and data ownership boundaries that are better left independent. The … links but have only local access needs. The partition is not integral to the organization at large

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Materialized Views

Partition Change Trackingpartition, is known as Partition Change Tracking (PCT). When one or more of the detail tables are … correspond to a modified detail partition(s); those rows become stale when a partition is modified while all … other rows remain fresh. Partition Change Tracking can be used to identify which materialized

Reference, 9i Release 2 (9.2.0.2)

SQL Statements and Operators

Merge Partition SyntaxALTER TABLE [schema.]table MERGE PARTITIONS partition1, partition2 [INTO PARTITION [new_partition … ] [partition_description]] Applies only to a range partition. This command merges the contents of two … adjacent partitions into a new partition and then drops the original two partitions. If the … resulting partition

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Parallelism and Partitioning in Data Warehouses

Miscellaneous Partition OperationsThe following partition operations are needed on a regular basis: Adding Partitions Dropping

Administrator's Guide, 9i Release 2 (9.2.0.2)

Storing Tablespaces on Raw Partitions

Creating an Extended PartitionOnly one extended partition can be created for each disk. You can use free space in the extended … partition to create multiple logical partitions or use all or part of it when creating volume sets or … other kinds of volumes for fault-tolerance purposes. To create an extended partition: Choose Start … bottom left, indicating

Reference, 9i Release 2 (9.2.0.2)

SQL Statements and Operators

Add Partition SyntaxALTER TABLE [schema.]table ADD PARTITION [partition] VALUES LESS THAN (value_list … ) [partition_description] Adds a new partition to the high end of a range partitioned table. To add a partition at the … beginning or in the middle of the table, use ALTER TABLE SPLIT PARTITION. The newly added table

Reference, 9i Release 2 (9.2.0.2)

SQL Statements and Operators

Split Partition SyntaxALTER TABLE [schema.]table SPLIT PARTITION partition_name_old AT (value_list) [into … (partition_description, partition_description)] [prallel_clause] Applies only to range partition. This command … divides a table partition into two partitions, thus adding a new partition to the table. The local … -empty. You

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Parallelism and Partitioning in Data Warehouses

Partition-Wise JoinsPartition-wise joins reduce query response time by minimizing the amount of data exchanged among … environments, partition-wise joins also avoid or at least limit the data traffic over the interconnect, which … is the key to achieving good scalability for massive join operations. Partition-wise joins can be … full or partial.

Reference, 9i Release 2 (9.2.0.2)

SQL Statements and Operators

Exchange Partition SyntaxALTER TABLE [schema.]table EXCHANGE PARTITION partition WITH TABLE table [INCLUDING|EXCLUDING … INDEXES} [WITH|WITHOUT VALIDATION] [EXCEPTIONS INTO [schema.]table] Converts a partition to a non … -partitioned table and a table to a partition of a partitioned table by exchanging their data segments … partition

Heterogeneous Connectivity Administrator's Guide, 9i Release 2 (9.2.0.2)

Performance Tips

Using Gateways and Partition ViewsYou can use partition views with Oracle Transparent Gateways release 8 or higher. Ensure you adhere … OPTIMIZER_MODE to ALL_ROWS or FIRST_ROWS_K, or FIRST_ROWS. Indexes used for each partition must be the … optimizer, then make sure that each partition uses the same number of indexes and that you have indexed the … of the indexes