All Questions
2 questions
0
votes
1
answer
320
views
When to create local and global indexes in RANGE INTERVAL partition
We are making use of Oracle 12c RANGE INTERVAL partitioning where Oracle creates the partitions automatically based on the data.
Parent tables are partitioned based on RANGE INTERVAL, child tables ...
- 37
0
votes
1
answer
718
views
Oracle Automatic LIST partition using virtual column not allowing REFERENCE partition on child table
I’ve made an attempt to create partition on test table using virtual column. This approach is working good for PARENT or standalone tables. However, I cannot create REFERENCE partition on CHILD ...
- 37