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
PARTITION partname → Rebuilds 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
Partition Granules → When 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.
Partition Pruning → Partition 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
Logical Partition → A 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.
Partition Views → Partition 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,
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
Migrate Partition Views to Partition Tables → Partition 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
Raw Partition Overview → raw 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
Truncate Partition Syntax → ALTER TABLE [schema.]table TRUNCATE PARTITION [DROP|REUSE STORAGE] Removes all rows from a … partition in a table. Corresponding CONTEXT index partitions are also removed.
Modify Partition Syntax → Unusable 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
Reasons to Partition → Partitioning 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
Partition Change Tracking → partition, 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
Merge Partition Syntax → ALTER 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
Miscellaneous Partition Operations → The following partition operations are needed on a regular basis: Adding Partitions Dropping
Creating an Extended Partition → Only 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
Add Partition Syntax → ALTER 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
Split Partition Syntax → ALTER 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
Partition-Wise Joins → Partition-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.
Exchange Partition Syntax → ALTER 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
Using Gateways and Partition Views → You 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