Re: Import 00041 warnings

It is a warning, which means import was able to continue. In this particular case the view has been created, it failed to compile, so it is invalid. Usually this is a problem of an incorrect sequence of events (ie the view relies on an object which has yet been imported). The import is good, but you need to recompile the view manually by alter view <viewname> compile.

Hth,

Sybrand Bakker, Oracle DBA

"Feldman Roger" <qrarofe_at_era.ericsson.se> wrote in message news:3A34FFAF.BC67F80D_at_era.ericsson.se...
> Oracle People:
>
> While importing with the following command I received the following
> error:
>
> $imp fromuser=REQPRO file=rational_export.dmp log=reqpro
>
> ------------
> IMP-00041: Warning: object created with compilation warnings
> "CREATE FORCE VIEW
> "REQPRO"."RQATTRVALUESVIEW_11" ("
> ""REQUIREMENTID","FIELDVALUE") AS "
> "SELECT RequirementID, RQ_STR_TO_STRING(FieldValue) AS FieldValue from
> Reqpr"
> "o.RqUserDefinedFieldValues WHERE FieldID = 11"
>
> Import terminated successfully with warnings.
> --------------
>
> Are these warnings serious ? I don't really understand what they mean or
> if the import is "good".
>
> Thanx,
>
> Roger
>
Received on Mon Dec 11 2000 - 11:44:28 CST