Re: move a row from table t1 to t2

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Thu, 1 Feb 2007 18:20:29 +0000 (UTC)
Message-ID: <eptb1d$1vs$1@klatschtante.init7.net>

On 2007-02-01, Prasath <prasath.rao_at_gmail.com> wrote:
> Table t2 is used to stored aged data. Hence, using view is not the
> solution I am looking for.

If you want to store 'aged data' away, you might be interested in Oracle's workspace manager. I have written about it in my blog at

http://www.adp-gmbh.ch/blog/2006/05/16.php

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch

Received on Thu Feb 01 2007 - 12:20:29 CST

This message: [ Message body ]
Next message: Redrobot5050: "Invalid Dates and Exception Handling in PL/SQL"
Previous message: Lucho: "Re: Doubt on optimizer costs when using date and subquery on dual"
In reply to: Prasath: "Re: move a row from table t1 to t2"
Next in thread: Ana C. Dent: "Re: move a row from table t1 to t2"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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