Will be executed REALBASENEXT partition REALBASE2010Q1 diverged in a statement:
The alter table REALBASE SPLIT PARTITION REALBASENEXT ats (TO_DATE (' 2010-04-01 00:00:00 ', 'SYYYY - MM - DD HH24: MI: SS')) INTO (PARTITION REALBASE2010Q1, PARTITION REALBASENEXT)
Results successfully separated, but the partition takes up a lot of space, the view is separated when the initial allocation of 2 g, consult everybody, how will the size change,
Content is as follows:
REALBASE2010Q1 TO_DATE (' 2010-04-01 00:00:00 ', 'SYYYY - MM - DD HH24: MI: SS', 'NLS_CALENDAR=the GREGORIAN) in tablespace nbscada pctfree 10 initrans 1 maxtrans 255 storage (initial 2048 m next 1 m minextents 1 the maxextents unlimited)
REALBASENEXT MAXVALUE in tablespace nbscada pctfree 10 initrans 1 maxtrans 255 storage (initial 2048 m next 1 m minextents 1 the maxextents unlimited)
REALBASENEXT initial is 2 g space, separated by default is 2 g,