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: Ana C. Dent <anacedent_at_hotmail.com>
Date: Fri, 02 Feb 2007 02:43:39 GMT
Message-ID: <Xns98CABE83B40A3anacedenthotmailcom@69.28.173.184> 





"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
Received on Thu Feb 01 2007 - 20:43:39 CST












Original text of this message













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