I need to split an Oracle partition, and I'm confused about whether or not Oracle is going to physically relocate the data when I execute the split. Here's what I intend to do:
alter table SCHEMA.DATATABLE split partition MAXVAL_PART at (TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition PARTFOREXISTINGROWS tablespace EXISTINGMAXVALTABLESPACE, partition MAXVAL_PART tablespace NEWMAXVALTABLESPACE);
The problem is that my current MAXVAL_PART has 320 GB of data in it, and I don't want to physically move this data on the disk. If I cut off the partition at 2013-04-01, then there will be no data in the new partition, but I'm getting conflicting information about whether this will still necessitate a move of all the data. Ideally, Oracle sees that my new MAXVAL partition will be empty, defines it in the new table space, and I'm all done.
Will this command move the data that's already on the disk, or will it leave it in place and just create a new partition?
This article says Oracle will detect the empty partition and do a fast split http://docs.oracle.com/cd/B19306_01/server.102/b14231/partiti.htm
But I see in a number of places that a split means all data gets moved to new storage. Which is it?