partition

Hash partitioning in oracle

Hash partitioning is one of the partitioning method, where hash algorithm is used to distribute data equally among multiple partitions. It is usually used for large tables, where we can’t use RA...

TRUST_EXISTING_TABLE_PARTITIONS in oracle 12.2 datapump

                TRUST_EXISTING_TABLE_PARTITIONS is a new option for the parameter data_option in the impdp utility of Oracle 12.2. Previously, If we are loading data to an existing partitioned...

Find row count of all partitions of a table

Below script is for finding the row counts of all partitions of a table in Oracle. [crayon-5beb0ed581731191252284/]

Read only Partition in Oracle 12.2

Till now we can make a table read only, But what about setting few partitions of a table to read-only. Thanks to Oracle 12.2 Release, We can do this. This is usually helpful, If requirement is to mak...

ORA-14400: inserted partition key does not map to any partition

While inserting data to a partitioned table, got below error.   SQL> insert into RANGE_TAB values(to_date(‘24032016′,’ddmmyyyy’),100); insert into RANGE_TAB values(to_d...

Partitioning New features in Oracle 12c

Below are the partitioning enhancements that has been introduced in Oracle 12c version. 1. Online partition move: From oracle 12c, we can move partitions online without blocking the DML statements dur...

Skip to toolbar