Tuesday, 15 March 2011

oracle - How to insert data in partition table which is not defined in partition? -


Anyone can tell me how to insert data into the partition table, which is not satisfactory to the condition of the partition.

You will get an error of ORA-14400:

  SQL & gt; ; Table T (id number) 3 by 2 range range (id) (split T1 value at least (100), 4 percent less than T2 values ​​(200) 5); Table sql and gt; Insert T values ​​(1); 1 line sql and gt; Put it in T values ​​(201); Insert in T values ​​(201) ~ ORA-14400: The split key entered does not map any partitions  

To avoid this, you low THAN (MAXVALUE) < / Code>:

  SQL & gt; Rank 3 (less than the T1 values ​​of less than (100), less than 4 part T2 values ​​(200), 5 part tmax values ​​(MAXVALUE) 6; Created table  

No comments:

Post a Comment