Re: Export/Import
From: Joe Nardone <joe_at_access1.digex.net>
Date: 1996/04/16
Message-ID: <4kv23j$ir2_at_news4.digex.net>#1/1
Date: 1996/04/16
Message-ID: <4kv23j$ir2_at_news4.digex.net>#1/1
Carlos A. Gonzalez (cagosg_at_hal-pc.org) wrote:
:
: but I also get this error:
:
: ORA-4063 view "XXXXX" has errors. Not clear, Checked the original
: views and I could select all the rows.
:
: What is that I am overlooking ???
:
Views are exported/imported in alphabetical order. If for some reason views are created from other views, the base views may not exist yet.
Example:
View DEF joins views ABC and XYZ. This view would be initially invalid because XYZ doesn't exist at the time DEF is imported.
The solution is to reimport, skipping objects that already exist.
Joe
--
=------------------------------------------------------------------=
Joe Nardone <joe_at_access.digex.net>
"Me fail English? That's unpossible!" - Ralph Wiggum
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: 2.6.2
mQBtAzCg5QoAAAEDANvEmc4OAT8wntnCv8UPjyD2kohKVGa1CU21PLpYljzl3AE7
pldpNNscKSoE//aVMKYBO+tRFTTsPNi0qZ6CDlEBXTgJAiszoHh1qCzZyYj7FTBL
YoUr+3sk9rU8Pma6AQAFEbQiSm9lIE5hcmRvbmUgPGpvZUBhY2Nlc3MuZGlnZXgu
bmV0Pg==
=1ocE
-----END PGP PUBLIC KEY BLOCK-----
Received on Tue Apr 16 1996 - 00:00:00 CEST