Re: Export/Import

Joe Nardone wrote:
>
> 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-----Joe:

I did reimport the XXX.DMP file with IGNORE=N and ROWS=N. Message 4063 still show up

Thanks
Joe Nardone wrote:
>
> 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-----Joe :

I did reimport the XXX.DMP file with IGNORE=N and ROWS=N. Msg still shows up

Thanks

Carlos Received on Tue Apr 16 1996 - 00:00:00 CEST