Re: Question about partition table.

From: Lev Smirnov <leo_at_dionis.sura.com.ru>
Date: Thu, 12 Oct 2000 07:07:05 GMT
Message-ID: <8s3nun$qia$1@nnrp1.deja.com>

In article <MKbF5.20$DL3.1420373_at_news.interact.net.au>,   "Chuan Zhang" <chuan_at_asiaonline.net> 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
>
>

1. Create partitioned table NEW_TABLE.
 CREATE TABLE NEW_TABLE(ID NUMBER(2) NOT NULL,

                        NAME VARCHAR2(20) NOT NULL)

  PARTITION BY RANGE(ID)
  (PARTITION T1 VALUES LESS THAN(1000)); 2. ALTER TABLE NEW_TABLE EXCHANGE PARTITION T1 WITH OLD_TABLE    WITH VALIDATION; See "Oracle8i Administrator's Guide" "Managing Partitioned Tables  and Indexes" for details.

Lev Smirnov
Brainbench MVP for Oracle Admin
http://www.brainbench.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 12 2000 - 02:07:05 CDT