RE: dump whole database to SQL text file
- From: "Ken Naim" <kennaim@xxxxxxxxx>
- To: <dennis@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 2 Sep 2008 18:16:09 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Dennis Yurichev
Sent: Tuesday, September 02, 2008 4:45 PM
To: oracle-l@xxxxxxxxxxxxx
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-----
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
