Re: Can I historize tables?

From: Jusung Yang <jusungyang_at_yahoo.com>
Date: 13 Sep 2002 13:06:01 -0700
Message-ID: <42ffa8fa.0209131206.94bfed6_at_posting.google.com>


You can use Flashback query. The query looks like

select ... from ... AS OF ...

You specify the time as of when you would like to see the version of the table. Look up ORACLE manual to see how to set up your database for Flashback query.

urswagner_at_bluemail.ch (Urs) wrote in message news:<d817deb6.0209130343.175dd83f_at_posting.google.com>...
> Hello
>
> I have always to import some code tables from another system.
>
> I would like to save the old tables content. Because sometimes I have
> to go back to the old version?
>
> What is the best way to do this?
>
> Thanks
>
> Urs
Received on Fri Sep 13 2002 - 22:06:01 CEST

Original text of this message