Database Administration (MOSC)

MOSC Banner

how to alter a subpartition

edited Nov 5, 2014 6:16AM in Database Administration (MOSC) 5 commentsAnswered ✓

how to add extents for subpartitions. Like this case:

OWNER SEGMENT_TYPE

------------------------------

SEGMENT_NAME

----------------------------------------

XXX TABLE SUBPARTITION

XX_TEST_EXTENT_LOG_PART

+++++++++++++++++++++++++++++++++++++

Query below does not help in adding extents to subpartitions

SQL> alter table test_extent allocate extent(size 5m); (adds 5 extents to the table)

Thank you, Ramesh

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