Re: TableSpace

From: Colin Sutherland <c.sutherland_at_easynet.com>
Date: Sat, 23 May 1998 01:22:50 +0100
Message-ID: <6k6ev9$pi3$1@apple.news.easynet.net>

You can recreate the tables in another tablespace by the use of

create table xxxxxx AS
(select * from table yyyyy)
tablespace tablespace_name

This will recreate the table from system to the tablespace_name tablespace. Then drop the tables in the system tablespace and if needed rename the new tables in the correct tablespace.

HTH Colin.

Becky Innocent wrote in message <6k26n8$gus$1_at_lccma.moat.platsol.com>...
>I need help moving 25 tables from SYSTEM to a new tablespace. Before
>creating the tables, I didn't know to create a new tablespace or opted
>not to at the time. Now, I am going to need to migrate from 7.3 to 8.0.
>From what I've read, the migrate utility will not migrate objects
>residing in the SYSTEM tablespace. Besides, I have since learned that it
>is not good practice to make SYSTEM my working tablespace (corruption
>issues).
>
>I tried exporting than importing the tables to a user whose default
>tablespace is the new one but that didn't seem to matter. It defaulted
>back to system anyway.
>
>Any and all help will be appreciated.
>
>Thanks.
>
>
>
>
Received on Fri May 22 1998 - 19:22:50 CDT