Re: move a table

From: Chet West <chetwest_at_carolina.rr.com>
Date: Wed, 04 Apr 2001 02:20:36 GMT
Message-ID: <Uxvy6.4396$Ho5.2078349@typhoon.southeast.rr.com>

Rename the original table
Create the new table with new storage info.
Insert into select * from...

TOAD has a nice utility for this.

Chet WEst

"Naushi Hussain" <naushi.hussain_at_alliedsignal.com> wrote in message news:3AA95A24.9CE2152C_at_alliedsignal.com...
> I need to move a table from one datafile to a datafile on another drive
> on the same database and keeping the same schema
>
> any ideas?
>
Received on Tue Apr 03 2001 - 21:20:36 CDT