Database Administration (MOSC)

MOSC Banner

Concurrent Execution of DROP TABLE and SHRINK TABLE: Safety and Archive Log Impact

When managing database tables, I have two related questions. First, is it safe to execute DROP TABLE and SHRINK TABLE commands at the same time if they are being applied to different tables? Are there any potential conflicts or issues that might arise from running these operations concurrently?

Second, while I understand that running SHRINK TABLE on multiple tables can generate a significant amount of archive logs, I’m curious whether the DROP TABLE command also results in a substantial increase in archive log output. Could you clarify the impact of DROP TABLE on archive log generation?

Version : 10.2.0.5.0

Tagged:

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