RE: dump whole database to SQL text file

Depending on which features of the database you use, this can be a simple or complex task. If all you are using are tables, views, indexes, constraints, pl/sql etc. then a few simple scripts spooled to text files is relatively simple. If you are lobs, spacial, materialized views, advanced queuing etc. then it becomes a difficult task as the scripts can take a long time to develop.

Many applications have already done most of the work for you. TOAD for example can compare schemas, and various database level items and can provide ddl to correct any differences.

If those databases have to be identical, I would clone one over the other. Or if it is just one schema, then drop it and import from the other assuming it is small enough. If they are both production instances, then Master-Master replication is needed, or some more custom solution just for certain objects.

Ken

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Yurichev
Sent: Tuesday, September 02, 2008 4:45 PM To: oracle-l_at_freelists.org
Subject: 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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 02 2008 - 17:16:09 CDT