RE: Breaking a Table Data into Partitions

Sorry, I don't have any example. However what I did when I had to was INSERT /*+ APPEND */ select.

Regards.

> -----Mensaje original-----
> De: VIVEK_SHARMA [SMTP:VIVEK_SHARMA_at_infy.com]
> Enviado el: miércoles 14 de febrero de 2001 14:22
> Para: 'ORACLE-L_at_fatcity.com'; 'CTrassens_at_uni2.es'
> Asunto: RE: Breaking a Table Data into Partitions
>
> Trassens ,
>
> Qs Which of the 3 , exp/imp , insert select , exchange partitions is MOST
> Advisable ?
>
> Qs Could you Give an EXAMPLE , if possible ?
>
> The Oracle Documentation CD has a Bad Example .
>
> In Exchange Partitions , for Range partitions :-
>
> Qs. Will the New Partition Table Name be the Same OR Different from the
> Original NON-partitioned Table Name ?
> Qs. Will 2 times the Space be Required in the Database to Break a Table
> into
> partitions
> (that taken by the Original Table & that by the Newly Created
> Partition
> Table ) ?
>
> Thanks
>
>
> > -----Original Message-----
> > From: Trassens, Christian [SMTP:CTrassens_at_uni2.es]
> > Sent: Wednesday, February 14, 2001 4:16 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Breaking a Table Data into Partitions
> >
> > With exp/imp or insert select or exchange partitions.
> >
> > Regards.
> >
> > > -----Mensaje original-----
> > > De: VIVEK_SHARMA [SMTP:VIVEK_SHARMA_at_infy.com]
> > > Enviado el: miércoles 14 de febrero de 2001 10:56
> > > Para: Multiple recipients of list ORACLE-L
> > > Asunto: Breaking a Table Data into Partitions
> > >
> > >
> > > To Convert a Regular NON-Partitioned Table into Partitions , what
> > > approaches
> > > may be Taken ?
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: VIVEK_SHARMA
> > > INET: VIVEK_SHARMA_at_infy.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Trassens, Christian
> > INET: CTrassens_at_uni2.es
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Trassens, Christian
  INET: CTrassens_at_uni2.es

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).