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

Home -> Community -> Usenet -> c.d.o.misc -> Re: move a row from table t1 to t2

Re: move a row from table t1 to t2

From: Jerome Vitalis <vitalismanN0SP4M_at_gmail.com>
Date: Sat, 03 Feb 2007 20:36:50 +0100
Message-ID: <45c4e452$0$3462$a3f2974a@nnrp1.numericable.fr>


Ana C. Dent wrote:
> "Prasath" <prasath.rao_at_gmail.com> wrote in news:1170346209.864715.221880
> @q2g2000cwa.googlegroups.com:
>

>> Table t2 is used to stored aged data.  Hence, using view is not the
>> solution I am looking for.
>>

>
> Just use partitioning & move the partition from current_table to
> archived_table

To move just one row? Received on Sat Feb 03 2007 - 13:36:50 CST

Original text of this message

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