Re: Export/Import

In article <4kv23j$ir2_at_news4.digex.net>, joe_at_access1.digex.net says...
>
>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

I believe you can also use :

   alter view viewname compile

to validate those views which had errors on import. This will "re-compile" or "re-parse" the view. And may be easier than re-importing if only a few views are involved.

Babette Dale Underwood (dale_at_fox.nstn.ca) Received on Sat Apr 20 1996 - 00:00:00 CEST