Database Administration (MOSC)

MOSC Banner

Splitting Oracle Datafiles

edited Feb 12, 2015 10:03AM in Database Administration (MOSC) 8 commentsAnswered
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.

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