Ora 14402 updating partition key column
—LOCAL REPLICATE THE ERROR:——————– create table partition_test( key number(5)) partition by range(key) (partition p1 values less than (100), partition p2 values less than (200), partition p3 values less than (300), partition p4 values less than (maxvalue)); Table created.
Get complete coverage of all objectives for exam 1Z0-047.Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques.An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included.Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more.Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML.ERROR: ORA-14402 Cause: An UPDATE statement attempted to change the value of a partition Key column causing migration of the row to another partition Action: Do not attempt to update a partition key column or make sure that The new partition key is within the range containing the old Partition key.; To reproduce ORA-14402 issue, we will need to create a partitioned table and then try to update the data from partition key column.
Below, we will create a partitioned Table, Insert some records and update the records that we just inserted to replicate the error ORA-14402.
Author: Write powerful SQL statements and PL/SQL programs.
Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price.
This book contains everything you need to master SQL.
Author: Implement Proven Database Optimization Solutions. Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec.
Prepare for the Oracle Certified Associate SQL Certified Expert exam with help from this exclusive Oracle Press guide.