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...
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. 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-14074: partition bound must collate higher than that of the last partition
While adding a partition to a partitioned table, got below error. SQL> alter table dbaclass_QTAB add partition dbaclass_q4 VALUES LESS THAN (TO_DATE(’01-APR-1998′,’DD-MON-Y...
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...