Re: VIEW, PACKAGE_BODY:OLAPSYS... created with compilation warnings ?... Basic Qs

That could be where OLAP was installed in the source database but not in the target database.

At 11:35 AM Friday, VIVEK_SHARMA wrote:
>Folks
>
>200 Errors (few samples below) Occurred when
>doing impdp (from a FULL Database Dump) into an Empty Database:-
>ORA-39082: Object type
>VIEW:"OLAPSYS"."OLAP_SYS_AW_ACCESS_DIM_VIEW" created with compilation warnings
>ORA-39082: Object type
>VIEW:"OLAPSYS"."OLAP_SYS_AW_ACCESS_CUBE_VIEW" created with compilation warnings
>…
>
>ORA-39082: Object type
>PACKAGE_BODY:"OLAPSYS"."CWM$CLASSIFY" created with compilation warnings
>ORA-39082: Object type
>PACKAGE_BODY:"OLAPSYS"."CWM$OLAP$CUBE" created with compilation warnIngs

Hemant K Chitale
http://hemantoracledba.blogspot.com

"A 'No' uttered from the deepest conviction is better than a 'Yes' merely uttered to please, or worse, to avoid trouble." Mohandas Gandhi Quotes
: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html

--
http://www.freelists.org/webpage/oracle-l