Re: move a table

From: Valery Yourinsky <vsu_at_bill.mts.ru>
Date: Mon, 09 Apr 2001 17:57:04 +0400
Message-ID: <3AD1BFB0.53F1A04@bill.mts.ru>

Roxl wrote:
>
> > 1. Rename the original table
> > 2. Create the new table with new storage info.
> > 3. Insert into select * from...
>
> A better way is to use the SQL*Plus command COPY, which commits
> periodically. For 'large' tables, the single transaction method will fail.

In Oracle8i youu can use

     ALTER TABLE table_name 
        MOVE tablespace_name STORAGE (...) ...

Valery Yourinsky

-- 
Oracle8 Certified DBA
Moscow, Russia

Received on Mon Apr 09 2001 - 08:57:04 CDT