dump whole database to SQL text file

-----BEGIN PGP SIGNED MESSAGE-----

Hash: SHA1

Hi!

I'm looking for reliable method to export all database content to SQL script, which, in future, may be run on empty database and thus to recreate it.
(Just as it is done in MySQL dump utility). I would also like to compare these dump scripts by *NIX diff utility. Yes, I understand how clumsy this is!

Or, does anybody know how to compare two databases precisely and see the difference?

• -- My PGP public key: http://yurichev.com/dennis.yurichev.asc
  -----BEGIN PGP SIGNATURE-----
  Version: GnuPG v1.4.8 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAki9pecACgkQ1YPmFmJG++MtMwCgvRjNcNOMLRSrzTrYS49j4hEZ A68Ani1Ne2A5/tmh3MVWOOCZAqJqGDpN
=hjBH
-----END PGP SIGNATURE-----

--
http://www.freelists.org/webpage/oracle-l