Hi all,
We are using SQLcl (25.4.2) and the project command to manage development of our application.
The issue we are running into is where a table has been “un-partitioned”, i.e. the partitioning is not required. Therefore the developer has recreated the table in the database without partitioning . The table exports fine, but the issue arises when they issue the project stage command. It compares it to what is in the main branch (which was partitioned) and comes back with the error:
ERROR: The following files were not processed, please confirm they have a hash at the bottom of the file and all other content is correct. Once they are corrected please rerun the stage command
Running it with -verbose -debug shows what the issue is (snipped for brevity):
getting the following output : -- ORA-39266: Cannot add, remove, or modify partitioning attributes.
Therefore, my question is, what is the correct way to “un-partition” a table whilst maintaining history with SQLcl, project and git?
Thanks in advance.