Are there any partition maintenance operations (add, drop, ...) happening when you get this error?
Anuj Gupta, February 04, 2020 - 5:18 pm UTC
No, there is no DDL partitioning operation happening.
February 04, 2020 - 6:09 pm UTC
Is the table interval partitioned? If so, inserting values for new partitions will cause the database to issue the DDL to create a partition.
Is table interval partitioned
Anuj Gupta, February 04, 2020 - 8:46 pm UTC
Table in which we are inserting(In example t) the records is not partitioned at all.
February 05, 2020 - 8:31 am UTC
What about the tables used in the view? What other activity is on those?
A reader, February 05, 2020 - 1:35 am UTC
Insert is on t however cursor is on view which is built on T1 & T2 both are partitioned
What about the tables used in the view? What other activity is on those?
Anuj Gupta, February 06, 2020 - 10:45 am UTC
Tables in the views are interval partitioned. No other activity happening on these while this insert is running.
February 06, 2020 - 1:07 pm UTC
Something else is happening to invalidate the cursor. You'll need to investigate what's happening at the time to find out what.