Re: Help: Moving tables and indexes from one tablespace to another
From: Hans E. Rasmussen <hrasmuss_at_sn.no>
Date: 1996/08/29
Message-ID: <3225C717.4D5E_at_sn.no>#1/1
Randy H wrote:
>
> Hi,
>
> I currently have a tablespace made up of several raw partions (extents) that
> contains both tables and indexes. This is heavily used. My plan is to create
> two new tablespaces (made up of one raw partition each) and then move all the
> indexes to one tablespace and all the tables to the second tablespace.
>
> What is the best way to do this? Should I export just the tables and then
> just the indexes (is this possible). I want to keep the original tablespace
> intact so users can access it until it is time to switch them over to the new
> setup.
>
> Thanks in advance for any help you can give me on this.
>
> - Randy Hills
Received on Thu Aug 29 1996 - 00:00:00 CEST
Date: 1996/08/29
Message-ID: <3225C717.4D5E_at_sn.no>#1/1
To splitt the tables and indexes to 2 different tablespaces should be simple. The easiest and fastest way would be to move only the indexes. Take the script which creates the indexes and change tablespace to the new name. Drop the indexes and create them again on the new tablespace.
---Hans Rasmussen---
Randy H wrote:
>
> Hi,
>
> I currently have a tablespace made up of several raw partions (extents) that
> contains both tables and indexes. This is heavily used. My plan is to create
> two new tablespaces (made up of one raw partition each) and then move all the
> indexes to one tablespace and all the tables to the second tablespace.
>
> What is the best way to do this? Should I export just the tables and then
> just the indexes (is this possible). I want to keep the original tablespace
> intact so users can access it until it is time to switch them over to the new
> setup.
>
> Thanks in advance for any help you can give me on this.
>
> - Randy Hills
Received on Thu Aug 29 1996 - 00:00:00 CEST