Re: Moving a table

In article <01bd5c91$a9fd1230$4c675cc3_at_ilewis>,   "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?
>
> Thanks in advance
>
> Ian
>

The simplest solution in my opinion would be :

CREATE table <new_table>
TABLESPACE <new_tablespace_name>
STORAGE (initial XXXm/k next YYm/k)
UNREOVERABLE
as select * from <old_table>;

Instead of select * from <old_table> U can specify the column names - this would enable u to change old column names, if required.

Specifying the UNRECOVERABLE clause will not generate any ROLLBACK and hence would be faster.
Hope this helps.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Mar 31 1998 - 00:00:00 CST