--- On Mon, 7/14/08, Kaare Rasmussen <[EMAIL PROTECTED]> wrote:
> But yes, it has to be enabled, and yes it has to have a
> performance cost
> somehow, but people are requesting it, and somehow I
AFAIK, It is built from undo so there is no ADDITIONAL overhead. It just saves
the undo that is cr
--- On Sat, 7/12/08, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> What I would appreciate as regards Oracle's flashback
> technology would
> have been a link to a well written review showing the warts
> as well as
> the beauty. I've found that Oracle stuff sounds good
> on paper, and
> turns into a
>
> Please don't put links to copyrighted material on our
> lists.
>
Postgres docs are copyrighted. The oracle docs are free to access just like
the postgres docs. What is the issue?
LewisC
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription
In addition to allowing you to read old data, Flashback will allow you to
rollback to a point in time, including returning a single table to a specific
state. Flashback database is like PITR without the log files.
It started in 9i and improved dramatically in 10g. 11g has made additional
im
How big are the underlying tables?
If they are large, are you partitioning?
Since the values only change daily, if the end result is a reasonable
size, have you considered using a CTAS rather than views?
LewisC
--- Ranieri Mazili <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I'm developing a BI and
Felix,
You might want to look at EnterpriseDB, which is PostgreSQL with
Oracle compatibility extensions.
www.enterprisedb.com
LewisC
--- Felix Zhang <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I'm a newbie of PostgreSQL. I'm searching materials about porting
> from
> Oracle to PostgreSQL.
> Any
