Re: dump whole database to SQL text file
- From: "David Barbour" <david.barbour1@xxxxxxxxx>
- To: dennis@xxxxxxxxxx
- Date: Tue, 2 Sep 2008 17:49:03 -0400
Uhmmmmm........for the first part - what about the exp utility? Yes, I
understand how clumsy this is, but export does precisely what you're
asking.
For the database comparison, are you looking for structure or structure and
data? Use a dblink and select from various dba views(dba_tablespaces,
dba_data_files, dba_tables, dba_tab_columns, etc.) to see the structural
differences. Yes, I understand how clumsy this is, but it works.
On Tue, Sep 2, 2008 at 4:45 PM, Dennis Yurichev <dennis@xxxxxxxxxx> wrote:
> -----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
>
>
>
Other related posts:
