On Fri, 8 Jun 2001, Matthew Tedder wrote:
..
> You've got to be kidding, a big database like Oracle doesn't have
> database dump utility? In PostgreSQL, you can dump the whole
> database's data and/or dump all the SQL commands needed to rebuild and
> re-populate a database, identically. This is very safe method of
> upgrading or even switching to a different RDBMS with a little
> conversion work on the SQL (if and where necessary).
Oracle imp/exp-style dumps are only compatible with Oracle. The
PostgreSQL- and MySQL-style "SQL statement dump" is not considered
efficient -- and it isn't!! just imagine doing 500 million inserts, with
the overhead of SQL parsing.
I guess Oracle never thought someone would want to shift away from Oracle
particularly after accumulating such a huge quantity of data.
--
Orlando Andico <[EMAIL PROTECTED]>
Mosaic Communications, Inc.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GE d(-) s: a-25 C++++ UBLSI++++$ P+++ L+++>++++ E- W++ N(+)
o K? w O-- M- !V PS(++) PE- Y PGP-- t(+)@ 5(+) X++@ R(+) tv@
b++ DI++ G e++@ h--(*) r% y+
------END GEEK CODE BLOCK------
