IMP-00041 Warning: object created with compilation warnings

Question

我看到网上的好多解决方案，都说在使用前重新编译无效对象就可以了。
我在PL—SQL Developer里重新编译后，没有invalid objects了。
但我想问，这能保证就是导入成功了吗？
有没有什么方法直接就显示导入成功没有警告的！
急，十分感谢！！！（我的导入命令：Imp prinergy/araxi@SynapseDBServer file=j:\icw_exp.dmp ignore=y full=y commit=y）

Answer 1

你 imp 的时候可以加一个 log 参数，输出日志，可以看到在什么地方有警告，然后根据你的警告来看一下是什么原因造成的例如可能是导出的数据库与导入的数据库字符集不同，这样会产生警告

Answer 2

-- IMP-00041 Warning: object created with compilation warnings
具体是不是执行权限的问题的导致的。

Answer 3

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsExport file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export client uses UTF8 character set (possible charset conversion)
. importing PRINERGY's objects into PRINERGY
. . importing table          "AUT_PERSISTEDACTION"          0 rows imported
. . importing table           "AUT_PERSISTEDEVENT"          0 rows imported
. . importing table                     "AUT_RULE"         14 rows imported
. . importing table                  "AUT_RULESET"          4 rows imported
……
……
……
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "PRINERGY"."DBCS_PATHLOCATION_R"                        ("
 ""PATHID","PATHPARENTID","PATHCOMPONENTNAME","PATHLOCATION") AS "
 "SELECT"
 "    PathId AS PathId,"
 "    PathParentId As PathParentId,"
 "    PathComponentName As PathComponentName,"
 "    DBCS_Paths.GetPathLocationById( PathId ) AS PathLocation"
 "FROM"
 "    DBCS_Path"
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "PRINERGY"."DBCS_JACKETLOCLISTITEM_R"                    "
 "    ("JCKDID","LISTKIND","LOCATIONNUMBER","FILESERVERNAME","SHARENAME","PAT"
 "HNAME") AS "
 "SELECT JLLI.jckdId                 AS jckdId,"
 "          JLLI.jacketLocListKindCd    AS listKind,"
 "          JLLI.jacketLocListItemNum   AS locationNumber,"
 "          DBCS_Paths.GetPathComponent(location, 1 )    AS fileServerName,"
 "          DBCS_Paths.GetPathComponent(location, 2 )     AS shareName,"
 "          (CASE WHEN jacketloclistPathid IS null"
 "                THEN jacketloclistitempathname"
 "                ELSE DBCS_Paths.GetPathComponent(location, 3 )"
 "           END ) AS pathName"
 "FROM (SELECT jckdId,"
 "             jacketLocListPathId,"
 "             jacketLocListKindCd,"
 "             jacketLocListItemNum,"
 "             jacketloclistitempathname,"
 "             DBCS_Paths.GetPathLocationById( jacketLocListPathId )AS locati"
 "on"
 "      FROM DBCS_JacketLocationListItem) JLLI"
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "PRINERGY"."DBCS_ITEMINDESCRIPTORGROUP_R"                "
 "        ("JCKDID","ITEMID","ITEMKINDCD","TASKTYPECD","ITEMWORKFLOWDESCID",""
 "ITEMPROCSTATEHISTLOGACTIONID","ITEMPROCSTATECONDCD","ITEMPROCSTATEMAJORCD","
 ""ITEMPROCSTATEMINORCD","ITEMROWVERSIONID","ITEMAPPRVLHISTLOGACTION","ITEMAP"
 "PRVLSTATECD","ITEMAPPRVLSTATECOMMENT","ITEMISVALIDFLAG","DESCGROUPID","DESC"
 "GROUPNAME","OPASSIGNMENTROWVERSIONID") AS "
 "SELECT   iwdo.JckdId As JckdId"
 "       , iwdo.ItemId As ItemId"
 "       , iwdo.ItemKindCd As ItemKindCd"
 "       , 0 As TaskTypeCd"
 "       , iwdo.ItemWorkflowDescId As ItemWorkflowDescId"
 "       , iwdo.ItemProcStateHistLogActionId As ItemProcStateHistLogActionId"
 "       , iwdo.ItemProcesStateCondCd As ItemProcStateCondCd"
 "       , iwdo.ItemProcStateMajorCd As ItemProcStateMajorCd"
 "       , iwdo.ItemProcStateMinorCd As ItemProcStateMinorCd"
 "       , iwdo.RowVersionId As ItemRowVersionId"
 "       , iwdo.ItemApprvlHistLogAction As ItemApprvlHistLogAction"
 "       , CAST( iwdo.ItemApprvlStateCd As NUMBER(2) ) As ItemApprvlStateCd"
 "       , iwdo.ItemApprvlStateComment As ItemApprvlStateComment"
 "       , iwdo.ItemIsValidFlag As ItemIsValidFlag"
 "       , wdg.DescGroupId As DescGroupId"
 "       , wdg.DescGroupName As DescGroupName"
 "       , wdg.OpAssignmentRowVersionId As OpAssignmentRowVersionId"
 "FROM     DBCS_ItemInWorkflowDescOp iwdo"
 "       , DBCS_WorkflowDescGroup wdg"
 "WHERE  iwdo.JckdId = wdg.JckdId"
 "       AND iwdo.ItemWorkflowDescId = wdg.DescGroupDescId"
 "UNION ALL"
 "SELECT   JckdId                  As JckdId"
 "       , ItemId                  As ItemId"
 "       , DBCS_IDLConstants.ConvertELMDTypeToRFILType(ItemKindCd)  As ItemKi"
 "ndCd"
 "       , TaskTypeCd              As TaskTypeCd"
 "       , DBCS_IDLConstants.GetSystemObject() As ItemWorkflowDescId"
 "       , ItemProcStateActionId   As ItemProcStateHistLogActionId"
 "       , ItemProcStateCondCd     As ItemProcStateCondCd"
 "       , ItemProcStateMajorActCd As ItemProcStateMajorCd"
 "       , ItemProcStateMinorActCd As ItemProcStateMinorCd"
 "       , RowVersionId            As ItemRowVersionId"
 "       , ItemApprvlStateActionId As ItemApprvlHistLogAction"
 "       , ItemApprvlStateCd       As ItemApprvlStateCd"
 "       , ItemApprvlStateCmmnt    As ItemApprvlStateComment"
 "       , 'T'                     As ItemIsValidFlag"
 "       , TaskDatabaseId          As DescGroupId"
 "       , TaskTemplateGroupName   As DescGroupName"
 "       , 0                       As OpAssignmentRowVersionId"
 "  FROM  DBCS_ItemInTaskTemplateGroup"
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "PRINERGY"."DBCS_JACKETSTATISTICINFO_R"                  "
 "      ("JACKETID","GROUPID","LASTFINALOUTPUTDATE","ONLINESTATECD","SUBPAGEC"
 "OUNT","APPROVEDSUBPAGECOUNT","SURFACECOUNT","NONFULLSURFACECOUNT","SEPARATI"
 "ONCOUNT","SEPFINALOUTPUTCOUNT","TASKPROCWARNINGCOUNT","TASKPROCERRORCOUNT","
 ""LASTARCHIVEDATE") AS "
 "SELECT"
 " JK.JckdId AS jacketId,"
 " JK.JckdGroupId AS groupId,"
 " JK.JckdLastFinalOutputDtm AS LastFinalOutputDate,"
 " JK.JckdOnlineStateCd AS OnlineStateCd,"
 " DBCS_JacketStatisticInfo.SubPageCount( JK.JckdId ) AS subPageCount,"
 " DBCS_JacketStatisticInfo.ApprovedSubPageCount( JK.JckdId ) AS approvedSubP"
 "ageCount,"
 " DBCS_JacketStatisticInfo.SurfaceCount( JK.JckdId ) AS surfaceCount,"
 " DBCS_JacketStatisticInfo.NonFullSurfaceCount( JK.JckdId ) AS nonFullSurfac"
 "eCount,"
 " DBCS_JacketStatisticInfo.SeparationCount( JK.JckdId ) AS separationCount,"
 " DBCS_JacketStatisticInfo.SepFinalOutputCount( JK.JckdId ) AS sepFinalOutpu"
 "tCount,"
 " DBCS_JacketStatisticInfo.TaskProcWarningCount( JK.JckdId ) AS taskProcWarn"
 "ingCount,"
 " DBCS_JacketStatisticInfo.TaskProcErrorCount( JK.JckdId ) AS taskProcErrorC"
 "ount,"
 " DBCS_JacketStatisticInfo.LastArchiveDate( JK.JckdId ) AS lastArchiveDate"
 "FROM"
 " DBCS_Jacket JK"
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "PRINERGY"."RPT_IMPPLANSUMMARY_V"                        "
 "("JCKDID","IMPPLANID","SIGNATURENUM","IMPPLANNAME","SURFACESHEETNUM","SIDEN"
 "UM","IMPPAGECNT","PAGECNT","ASSIGNEDPAGEPRFDCNT","SEPPRFDCNT","SEPOUTPUTCNT"
 "","SEPCNT") AS "
 "select  i.jckdId as JckdId,"
 " i.ImpPlanId,"
 " s.signatureNum as SignatureNum,"
 " cast (i.ImpPlanName as VARCHAR2(250)) as ImpPlanName,"
 " su.SurfaceSheetNum as SurfaceSheetNum,"
 "         su. SurfaceSideNum as SideNum,"
……
……
……"           b.wcsrevisionnum AS wcsrevisionnum"
 "    From TW_SPBundle b, TW_Folder f, tw_containerpath_r c"
 "    Where b.basefolderid = f.folderid"
 "      AND c.containerId = f.containerId"
 "      AND f.DeletedDTM IS NULL"
 "      AND c.DeletedDtm IS NULL"
IMP-00041: Warning: object created with compilation warnings
 "CREATE FORCE VIEW "PRINERGY"."TW_ELEMENTFILEWITHREFCOUNT_R"                "
 "        ("CONTAINERID","CONTAINERROOTPATH","CONTAINERTYPE","CONTAINERNAME","
 ""ELEMENTID","REVISIONSUBPATH","FILENAME","FILEID","MASTERFILEID","ELEMENTRE"
 "VISIONID","MACCREATOR","MACTYPE","REFCOUNT","REVDELETEDDTM","FILETYPE","HEA"
 "DREVISIONID","FOLDERID") AS "
 "SELECT"
 "    tf.ContainerId As ContainerId,"
 "    tf.ContainerRootPath As ContainerRootPath,"
 "    tf.ContainerType As ContainerType,"
 "    tf.ContainerName As ContainerName,"
 "    tf.ElementId As ElementId,"
 "    tf.RevisionSubPath As RevisionSubPath,"
 "    tf.FileName As FileName,"
 "    tf.FileId As FileId,"
 "    tf.MasterFileId As MasterFileId,"
 "    tf.ElementRevisionId As ElementRevisionId,"
 "    tf.MacCreator As MacCreator,"
 "    tf.MacType As MacType,"
 "    tref.RefCount As RefCount,"
 "    tf.DeletedDtm As RevDeletedDtm,"
 "    tf.FileType As FileType,"
 "    tf.HeadRevisionId As HeadRevisionId,"
 "    tf.FolderId As FolderId"
 "FROM TW_AllFile_R tf, TW_FILEREFCOUNT_R tref"
 "WHERE"
 "    tf.ContainerId = tref.ContainerId AND"
 "    UPPER(tf.FileName) = tref.FileNameUC AND"
 "    UPPER(tf.RevisionSubPath) = tref.RevisionSubPathUC"
About to enable constraints...
Import terminated successfully with warnings.
内容太长 只能贴这些啦