Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Partitioning Large *Existing* Table

Re: Partitioning Large *Existing* Table

From: Paul Brewer <nothing_at_nowhere.com>
Date: Sat, 24 Apr 2004 22:50:33 +0100
Message-ID: <408ae13c_1@mk-nntp-1.news.uk.worldonline.com>


"SAP BASIS Consultant" <basis_consultant_at_hotmail.com> wrote in message news:dd2036f3.0404211228.1af00c36_at_posting.google.com...
> Hello,
>
> I have researched 8i+ partitioning, and I understand how to create a
> partitioned table. Thus, for the sake of this posting, suppose that I
> would like to create a table TDATE partitioned by range, my
> understanding (Unfortunately, I don't have access to an Oracle system
> now) is that I would issue a command such as the following:
>
> CREATE TABLE TDATE ..... PARTITION BY RANGE(DATE) (PARTITION
> F1 VALUES LESS THAN ('01-APR-2001', 'DD-MON-YYYY', PARTITION
> F10...));
>
> However, suppose that there is a large (Say 10GB or 20GB) table
> named TDATE which is not partitioned, and which I would like to
> partition.
>
> Would I have to go through a procedure such as backing up the TDATE
> and/or copying it to a temp. table, exporting its data, deleting
> TDATE, recreating TDATE as a partitioned table, and reimporting the
> data into TDATE, or is there is an easier way to partition an existing
> table?
>
>
>
> Thanks in Advance,
> SAP BASIS Consulant

What's the consultancy rate?

Regards,
Paul Received on Sat Apr 24 2004 - 16:50:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US