Database Administration (MOSC)

MOSC Banner

dopping partition update index and UNDO generation

I have oracle 19c RAC on linux with pluggable database, on monthly basis maintenace activity occurs to drop old partitioin with almost 400GB

i would like to know if dropping the partition with update index

ALTER TABLE DROP PARTIOIN UPDATE INDEXES


would required use of UNDO tablspace as im noticing undo table space is getting bigger and bigger once this activity is being done, so wondering if its a coincidence or they are related

knowing that the drop statement is being done for almost 500GB from 20 Tables.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center