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