Re: Moving a table

You could export the table from the existing tablespace, rename or drop the table (my choice is to rename the table until you are sure your new table is ok), take the existing tablespace offline, alter the default tablespace for the owner of the table to the new tablespace, import the table into the new tablespace.

A second option (I think might be easier) would be to rename the existing table (eg. table_orig) then create a new table:

SQL> create table table_name

	tablespace new_tablespace
	-- storage parameters --
	as
	select * from table_orig;

you could then verify your tables by performing queries against both tables. When you are satisfied that the new table is reliable, you can drop the original.

Dave

Ian <Ian.Lewis_at_synectics-solutions.com> wrote in article <01bd5c91$a9fd1230$4c675cc3_at_ilewis>...
> 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?
>
> Thanks in advance
>
> Ian
>
Received on Tue Mar 31 1998 - 00:00:00 CST