Splitting Oracle Datafiles
Is it possible to split an OLAP tablespace over multiple datafiles?
How would one go about splitting a 300GB database file into 16GB Chunks, could I use a variation of the below process?
CREATE TABLESPACE glo DATAFILE
'disk1/oradata/glo1.dbf' SIZE 64M REUSE AUTOEXTEND ON NEXT 8M MAXSIZE 1024M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
ALTER TABLESPACE glo ADD DATAFILE
'disk2/oradata/glo2.dbf' SIZE 64M REUSE AUTOEXTEND ON NEXT 8M MAXSIZE 1024M,
'disk3/oradata/glo3.dbf' SIZE 64M REUSE AUTOEXTEND ON NEXT 8M MAXSIZE UNLIMITED;
The reason I ask is for backup performance, it is much quicker to backup multiple 16GB files (since it can be run parallel) then one 300GB file.
0