Using - Oracle 11g

I have created a table say X. of this table, a column say C3 is a computed column which will have a value based on incoming values for the other 2 columns say C1 and C2. I am using a BEFORE INSERT trigger for the same.

The table is partitioned by Range on the computed column C3 and this is a Date column.

Now, when I try to insert data into the computed column using a Trigger, the system dumps all data into the default partition rather than creating individual partitions. Instead, when I use the computation formula directly in my Insert query; the partitioning is fine and as expected.

Any idea?


  • It sounds like you haven’t set up interval partitioning and are just relying on the partitions you have manually set up. Set the interval if you want Oracle to automatically create the partitions. Mar 5, 2022 at 22:12

1 Answer 1


I sounds like you are doing partitioning based on a virtual column.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.