Moving tables to a new tablespace

September 9th, 2008 Posted in Oracle How-To

Need to move a table to a new tablespace?  That is just what I needed to do today.  I have a couple if hot datafiles that I need to relieve the load on.  Basically I have one staging tablespace for loading and manipulating data beforethe data is moved to the production tables.  I have several larger jobs that are now utilizing this tablespace.  There are two problems with my current setup.  Multiple jobs are hitting the tablespace at the same time and the tablespace is on a single RAID group.  This particualr server has two RAID groups so I created multiple stagin tablespaces (one for each job).  I also split the datafiles for these new tablespace across both RAID groups.  Move the tables was easy.

For my non-partitioned tables I used:

ALTER TABLE O1DW.STG_OSCAR_CALLPROC
MOVE TABLESPACE STG_CSE;

and for my partitioned tables I used:

ALTER TABLE O1DW.STG_OSCAR
MOVE PARTITION STOP_EVENT TABLESPACE STG_CSE;
Tags: ,
This entry was posted on Tuesday, September 9th, 2008 at 5:03 pm and is filed under Oracle How-To. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply