Home » RDBMS Server » Server Utilities » ora-39082 (10.2.0.4)
ora-39082 [message #493578] Tue, 08 February 2011 14:51 Go to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Experts,
I got following errros after i did impdp:-
ORA-39082: Object type ALTER_FUNCTION:"LOCREF1"."RETRIEVE_FIELD" created with co
mpilation warnings
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
ORA-39082: Object type ALTER_PROCEDURE:"LOCREF1"."PRCSAVESASSMOBILERECORDS" crea
ted with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"LOCREF1"."PURGEDISTR" created with compi
lation warnings
ORA-39082: Object type ALTER_PROCEDURE:"LOCREF1"."REQUEUE_PAY" created with comp
ilation warnings
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39082: Object type VIEW:"LOCREF1"."MBL_INCD_TEMP_V" created with compilation
 warnings
ORA-39082: Object type VIEW:"LOCREF1"."MBL_RECPT_TEMP_V" created with compilatio
n warnings
ORA-39082: Object type VIEW:"LOCREF1"."INTL_CARRIER_SCAN_V" created with compila
tion warnings
ORA-39082: Object type VIEW:"LOCREF1"."INVOIC_ADV_REC_V" created with compilatio
n warnings
ORA-39082: Object type VIEW:"LOCREF1"."PAY_ADJUST_V" created with compilation wa
rnings
ORA-39082: Object type VIEW:"LOCREF1"."GBS_DOT_CODE_T_V" created with compilatio
n warnings
ORA-39082: Object type VIEW:"LOCREF1"."INTL_CONTAINERS_T_V" created with compila
tion warnings
ORA-39082: Object type VIEW:"LOCREF1"."INTL_COUNTRY_T_V" created with compilatio
n warnings
ORA-39082: Object type VIEW:"LOCREF1"."INTL_GREAT_CIRCLE_MILES_T_V" created with
 compilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."INTL_MAIL_CATEGORY_T_V" created with comp
ilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."INTL_MAIL_CLASS_T_V" created with compila
tion warnings
ORA-39082: Object type VIEW:"LOCREF1"."INTL_MAIL_SUBCLASS_T_V" created with comp
ilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."CONTRACTOR_T_V" created with compilation
warnings
ORA-39082: Object type VIEW:"LOCREF1"."INTL_AIRLINE_T_V" created with compilatio
n warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_COUNTRY_T_V" created with compilation
 warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_DOCUMENT_TYPE_T_V" created with compi
lation warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_EQUIPMENT_TYPE_T_V" created with comp
ilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_MAILER_BARCODES_T_V" created with com
pilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_FACILITY_EACCESS_T_V" created with co
mpilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_FPA_PARAMETERS_T_V" created with comp
ilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_HOLD_REASON_T_V" created with compila
tion warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_ITEM_REFERENCE_T_V" created with comp
ilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_OPEN_TRANSIT_RATES_T_V" created with
compilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_PAPERWORK_REQUIREMENTS_T_V" created w
ith compilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_PARCEL_TRANSIT_RATES_T_V" created wit
h compilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_REBUT_CHARGES_T_V" created with compi
lation warnings
ORA-39082: Object type VIEW:"LOCREF1"."SDR_RATE_T_V" created with compilation wa
rnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_RETURN_REASON_T_V" created with compi
lation warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_SETTLEMENT_RATES_T_V" created with co
mpilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_STATISTICAL_SAMP_COUNTRY_V" created w
ith compilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."MILITARY_BRANCH_T_V" created with compila
tion warnings
ORA-39082: Object type VIEW:"LOCREF1"."INTL_MARITIME_PORTS_T_V" created with com
pilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."INTL_OFFICE_T_V" created with compilation
 warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_PTS_CBP_EVENTS_T_V" created with comp
ilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_IAT_CONTAINER_MINIMUMS_T_V" created w
ith compilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_EPG_ITEM_BARCODE_T_V" created with co
mpilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."CODE_SHARING_RELATIONSHIPS_T_V" created w
ith compilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_BI_LATERAL_DISALLOW_T_V" created with
 compilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."INTL_MILITARY_ZIPCODE_T_V" created with c
ompilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."GBS_FINANCE_ACCOUNT_T_V" created with com
pilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."MARITIME_LS_RATE_T_V" created with compil
ation warnings
ORA-39082: Object type VIEW:"LOCREF1"."GBS_PENALTY_T_V" created with compilation
 warnings
ORA-39082: Object type VIEW:"LOCREF1"."GBS_SCAN_RULE_T_V" created with compilati
on warnings
ORA-39082: Object type VIEW:"LOCREF1"."GBS_IRAS_T_V" created with compilation wa
rnings
ORA-39082: Object type VIEW:"LOCREF1"."GBS_FORCE_MAJ_T_V" created with compilati
on warnings
ORA-39082: Object type VIEW:"LOCREF1"."MARITIME_CONTRACT_RATE_T_V" created with
compilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."MARITIME_MILES_T_V" created with compilat
ion warnings
ORA-39082: Object type VIEW:"LOCREF1"."ADJUSTMENT_LOG_T_V" created with compilat
ion warnings
ORA-39082: Object type VIEW:"LOCREF1"."GBS_AIR_RATE_T_V" created with compilatio
n warnings
ORA-39082: Object type VIEW:"LOCREF1"."ADJUSTMENT_DETAIL_T_V" created with compi
lation warnings
ORA-39082: Object type VIEW:"LOCREF1"."GBS_CONTAINER_RATE_T_V" created with comp
ilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."UPU_DOT_RATE_T_V" created with compilatio
n warnings
ORA-39082: Object type VIEW:"LOCREF1"."GBS_CONTRACT_EXCEPTION_T_V" created with
compilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."GBS_MHC_T_V" created with compilation war
nings
ORA-39082: Object type VIEW:"LOCREF1"."GBS_SCHEDULE_BLOCK_T_V" created with comp
ilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."INTL_AIRPORT_T_V" created with compilatio
n warnings
ORA-39082: Object type VIEW:"LOCREF1"."MBL_INCD_V" created with compilation warn
ings
ORA-39082: Object type VIEW:"LOCREF1"."MBL_RECPT_V" created with compilation war
nings
ORA-39082: Object type VIEW:"LOCREF1"."GBS_DEMAND_BUCKET_T_V" created with compi
lation warnings
ORA-39082: Object type VIEW:"LOCREF1"."ISM_ON_HOLD_DESTINATIONS_T_V" created wit
h compilation warnings
ORA-39082: Object type VIEW:"LOCREF1"."PAY_THRSHLD_GRP_V" created with compilati
on warnings
ORA-39082: Object type VIEW:"LOCREF1"."INTL_SPECIAL_RATES_T_V" created with comp
ilation warnings
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
ORA-39082: Object type PACKAGE_BODY:"LOCREF1"."PKG2759" created with compilation
 warnings
ORA-39082: Object type PACKAGE_BODY:"LOCREF1"."SASS_RESDIT_PKG" created with com
pilation warnings
ORA-39082: Object type PACKAGE_BODY:"LOCREF1"."PRMT_LD_PKG" created with compila
tion warnings
ORA-39082: Object type PACKAGE_BODY:"LOCREF1"."PKG_CRT_RECPT_MNL_SCAN_ADJUST" cr
eated with compilation warnings

I have used dbms_utility and i tried compiling these
invalid objects manually but I could not compile them.
Can you please tell me the reason of these errors and
why could not i compile them manually or with package.
Re: ora-39082 [message #493579 is a reply to message #493578] Tue, 08 February 2011 14:55 Go to previous messageGo to next message
BlackSwan
Messages: 26756
Registered: January 2009
Location: SoCal
Senior Member
>i tried compiling these invalid objects manually but I could not compile them.

I tried to make my car go, but it does not go.
Why can't I make my car go?

>why could not i compile them manually or with package.
something is wrong but we can not access YOUR DB to determine exactly what/why warnings occurred.
Re: ora-39082 [message #493582 is a reply to message #493579] Tue, 08 February 2011 15:23 Go to previous message
varunvir
Messages: 363
Registered: November 2007
Senior Member
I figured out the issue.It was because of missing
database link in newly created schema.
Thanks,
Varun Punj,
Previous Topic: How to setup Data Pump resumable error timeout
Next Topic: Job Scheduler
Goto Forum:
  


Current Time: Sun Nov 29 05:03:29 CST 2020