This content has been marked as final. Show 1 reply
As the forum title says this forum is ONLY for SQL Developer questions.
Please mark this thread ANSWERED and repost it in the SQL and PL/SQL forum
When you repost provide your 4 digit Oracle version.
Use option #2 - drop the partition and let Oracle update the global indexes. Option #1 only adds the substantial overhead of a DELETE that unnecessarily uses both REDO and UNDO and can take time.
Better would be to use partitioned indexes and avoid the index updating altogether.
No other support will be provided in this forum. If you need more help than the above repost the question.