Re: Import - Errors in Views
Date: Mon, 6 Dec 1993 15:22:59 GMT
Message-ID: <CHMDEB.HB6_at_freenet.carleton.ca>
In a previous article, 0019411_at_msgate.emis.hac.com (Paul Hyman) says:
>I am attempting to export a user's objects from one database and import
>them
>into another one. The export works fine, but the import gives warnings
>on all
>the views saying that they have compilation errors. The text of the
>views as loaded
>into the second database appears fine. There is no indication of what
>the compilation errors were due to. Has anyone else seen this problem?
The actual tables on which the views are based are either not
present or not accessible on the new database. Once the base
tables become available the views will automatically recompile
when they are first used.
>
>I am running Oracle 7.0.12.1 on an HP 720 Using HP-UX 9.something.
There is a known bug with recompiling views created WITH CHECK OPTION on 7.0.12. If your incremental exports stop working suddenly, drop me e-mail and I'll send you the workaround.
--
- Doug Harris
Database Administrator,
System Development Division,
Statistics Canada ### Standard Disclaimer Applies ###
Received on Mon Dec 06 1993 - 16:22:59 CET