Re: Question about partition table.

Look at using the 'ALTER TABLE XXX EXCHANGE....' command. This will enable you to convert a normal table into a partition and vice versa.

Chuan Zhang wrote:

> Hi, ALL,
>
> I might ask a very simple question, but I need someone's help.
>
> We got some very large tables. but we haven't created them original as
> partition tables. Is there any way to alter them to pratition table without
> the cycle of creating a identical temporary table, dropping the table and
> recreating the table into partition?
>
> Thanks very much in advance.
>
> Chuan
Received on Thu Oct 12 2000 - 02:42:43 CDT