Re: How to find out version and install security patches?

Hello,

On Jun 1, 6:18 pm, Mladen Gogala <mgog..._at_yahoo.com> wrote:
> The "pg_dump" program used with the .sql extension (without -F c) is
> akin to Oracle export/import. As is the case with PgSQL, which produces
> SQL script to be "restored" by psql, SQL format is much slower to restore
> then the "custom" format, which is a physical backup to be restored by
> pg_restore.
>
> So, in the world of Oracle, you could create a "snapshot" by using the
> export utility. Here I wholeheartedly advise you to go to at least oracle
> 10g as "data pump" versions are much faster and restartable.
> If you want to create backup, you would normally use RMAN for that
> purpose. RMAN is much faster because it backs up physical data files.

Thanks for the info, I think I'll go with RMAN-backups then (I'm reading up on it). Upgrading to 10g is not an option, because the consultant told me the application (Mercury QMC) needs Oracle 9 (which is probably BS)...

Regards
Alex Received on Sun Jun 01 2008 - 13:06:38 CDT