0

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?

Thanx

Improve this question
1
  • 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.
    – Andrew Sayer
    Commented Mar 5, 2022 at 22:12

1 Answer 1

Reset to default
0

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

virtual_column_based_partitioning

Improve this answer

Your Answer

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

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