Database Administration (MOSC)

MOSC Banner

Split Partition command will allow DML operation simultaneously?

edited Oct 3, 2017 3:32AM in Database Administration (MOSC) 4 commentsAnswered ✓

I need to know if I run the below split partition command, will it allow DML operation simultaneously? (or will other users can continue with select, insert or update without any issue?)

ALTER TABLE RULES_AUDIT_LOG_PARAM_VAL

  SPLIT PARTITION RULES_AUDIT_LOG_PARAM_VAL_PM AT (252700008)

  INTO (PARTITION RULES_AUDIT_LOG_PARAM_VAL_P40 , PARTITION RULES_AUDIT_LOG_PARAM_VAL_PM);

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