I fiddled around, rechecked documentation and in desperation tried to just add the final, missing right parenthesis! And it worked! A statement with unmatched parenthesis! If I didn’t have OCD before…: alter table masters Into subpartition d_1000_jan2022, subpartition d_1000_def_yearmonth īut trying that gave “ ORA-00907: missing right parenthesis” as the response. ![]() Anyway – I tried removing the parenthesis, since that’s where the IDE indicated the error: alter table masters I rechecked the syntax and found it to be correct. Surprisingly enough, I got an error “ORA-14150: missing SUBPARTITION keyword”. Into (subpartition d_1000_jan2022, subpartition d_1000_def_yearmonth) I then wanted to test partition splits, checked the documentation and issued this command: alter table masters Partition q4_2005 values less than (to_date('0', 'DD-MON-YYYY'))įoreign key (order_id) references orders (order_id) Partition q3_2005 values less than (to_date('0', 'DD-MON-YYYY')), ![]() Partition q2_2005 values less than (to_date('0', 'DD-MON-YYYY')), Partition q1_2005 values less than (to_date('0', 'DD-MON-YYYY')), I had managed to create two tables like this, but after finding a workaround when doing it in DataGrip: create table ordersĬonstraint orders_pk primary key (order_id) Here’s another case where the combination of DataGrip and Oracle gave unexpected results. As previously described in this post, DataGrip cutting DDL short, case 1, I thought Oracle had some errors in the syntax. ![]() I was testing out diffent tings around reference partitioned tables in 19c. At first I thought Oracle had a lot of bugs in the partitioning syntax, but it turned out to be DataGrip messing with my DDL! Working on a case with reference partitioned tables, I came over some strange errors. My preferred tool for writing PL/SQL code has been DataGrip from JetBrains for the last few years.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |