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
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
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
>
> 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
--- 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
--- 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
