Re: Splitting a table after it is created?

On Sun, 22 Jul 2001, plovmand_at_hotmail.com wrote:

> create table mytab_1 as (select c1,c2......c251 from mytab);
> create table mytab_2 as (select c251,c253....c502);
>drop table mytab;

Just remember that mytab_2 needs to keep the primary key of mytab_1. So it will probably look like

create table mytab_1 as (select c1,c2......c251 from mytab); create table mytab_2 as (select c1,c251,c253....c502); drop table mytab;

-- 
Galen Boyer
It seems to me, I remember every single thing I know.