Re: Moving a table

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 1998/04/01
Message-ID: <6fsdg0$3v6@bgtnsc02.worldnet.att.net>#1/1

On 31 Mar 1998 10:34:37 GMT, "Ian"
<Ian.Lewis_at_synectics-solutions.com> wrote:

>We have an Oracle 7.3 database with 3 schema's.
>
>I would like to move a 2million record table to it's own tablespace (it is
>currently shared with another table). How can I move the table to this new
>tablespace?.
>
>Could I use the Table only import option - or will this store the table in
>the original tablespace?

I believe you can do the following:

export the table
drop the table.
recreate the table and assign it to the new tablespaces.
import the data and specify the "ignore create errors" option on the import.

You could probably also create a new table, insert the data from the old table into the new, drop the old table, and rename the new. With 2 million records, that would probably not be a good approach. I would try the export/import approach. Received on Wed Apr 01 1998 - 00:00:00 CST