partition

ORA-14024: number of partitions of LOCAL index must equal that of the

PROBLEM: While doing online redefinition of partitioned table, got ORA-012024 error. SQL> DECLARE 2 error_count pls_integer := 0; 3 BEGIN 4 DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS('RAJDBA', 'SOC_TA...

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. set serverout on size 1000000 set verify off declare sql_stmt varchar2(1024); row_count number; cursor get_tab is sel...

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...