Hi,
I am using ORACLE 11g R2 DB and IBM AIX OS.
I have faced a very different situation. I had last night's backup dump file of the user, in the morning we had some issue so we need to restore that dump in the current user. So i dropped the user first and then created it. Gave all the respective privileges and started the IMPDP process in which i passed the same dump file from last night's backup. This dump file belonged to the same user. So , the dump is of the same user in which it is getting imported.
But to my surprise all the pl/sql blocks(procedures,functions,packages) all have been imported in UPPERCASE. Even the comments and the single quotes values by which we can do the data matching, all are turned into UPPERCASE. So we are facing a lot issue with it as data is not getting matched as per the procedure.
The user is passing the value as 'app server' and in the procedure the value is as "SELECT.......WHERE SERVER_NAME='APP SERVER' " . so the data is not matched and it returns no output. This is a case in many procedures and we found this only after we imported this dump file.
The IMPDP command is as follows:-
impdp \'sys as sysdba\' directory=remote dumpfile=dblink_ngpmt_mt_mt01_19-03-2012-13-10-20.dmp logfile=dblink_ngpmt_mt_mt01_19-03-2012-13-10-20.log remap_schema=MT01:mt01
The log file is as below :-
;;;
Import: Release 11.2.0.2.0 - Production on Tue Mar 20 17:22:26 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01": "sys/******** AS SYSDBA" directory=remote dumpfile=dblink_ngpmt_mt_mt01_19-03-2012-13-10-20.dmp logfile=dblink_ngpmt_mt_mt01_19-03-2012-13-10-20.log remap_schema=MT01:mt01
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"MT01" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "MT01"."FLX_CS_AUDIT_ITEM" 53.19 MB 5369 rows
. . imported "MT01"."FLX_CS_AUDIT_ITEM_LOG" 26.93 MB 197599 rows
. . imported "MT01"."FLX_RL_RULE_CODES" 13.16 MB 228 rows
. . imported "MT01"."XF_OL_ST_EXT_TXN_XREF" 6.913 MB 89083 rows
. . imported "MT01"."FLX_RL_EVALUATION_DTLS" 5.920 MB 51309 rows
. . imported "MT01"."FLX_SM_AUTH_REASON_CONFIG" 4.284 MB 29584 rows
. . imported "MT01"."FLX_RL_RULE_DRAFTS_B" 3.744 MB 228 rows
. . imported "MT01"."FLX_MD_SERVICE_ATTR_SRC" 888.0 KB 3807 rows
. . imported "MT01"."FLX_MD_FIELDS_DEFN" 3.517 MB 15758 rows
. . imported "MT01"."FLX_MD_SERVICE_ATTR" 658.7 KB 2173 rows
. . imported "MT01"."FLX_SM_SERVICE_INPUTS_B" 3.794 MB 26859 rows
. . imported "MT01"."FLX_PM_PRODUCT_FLOW" 376.6 KB 16 rows
. . imported "MT01"."FLX_RL_EXPRESSION_CODES" 1.825 MB 164 rows
. . imported "MT01"."FLX_PC_FIN_INST_B" 2.752 MB 14065 rows
. . imported "MT01"."FLX_MD_KEY_FIELDS" 2.400 MB 13367 rows
. . imported "MT01"."FLX_MD_SERVICE_INPUTS" 2.040 MB 13645 rows
. . imported "MT01"."FLX_MD_UI_TEXT_LABEL" 2.405 MB 6994 rows
. . imported "MT01"."FLX_ME_BUS_FUNC_QUERY_ID" 1.740 MB 7973 rows
. . imported "MT01"."FLX_EP_ACT_LOG_B" 1.456 MB 110 rows
. . imported "MT01"."FCR_TXN_SERVICE" 1.122 MB 8743 rows
. . imported "MT01"."FLX_PM_ACCT_ENTRY_TMPLT" 851.4 KB 5543 rows
. . imported "MT01"."FLX_SM_AUTHORIZATIONS_B" 862.7 KB 5654 rows
. . imported "MT01"."FLX_SM_SERVICES_DEFN" 1003. KB 5753 rows
. . imported "MT01"."FLX_PR_PLAN_LOG_B" 733.1 KB 45 rows
. . imported "MT01"."FLX_WL_WORKITEM" 637.9 KB 26 rows
. . imported "MT01"."FLX_FA_FACTS_B" 556.9 KB 2129 rows
. . imported "MT01"."FLX_ME_BUSINESS_OBJECT_B" 558.7 KB 4877 rows
. . imported "MT01"."FLX_WL_DRAFT_ITEM" 296.1 KB 41 rows
. . imported "MT01"."FLX_RL_RULE_EXPRESSIONS" 462.4 KB 7661 rows
. . imported "MT01"."FLX_RL_RULE_OUTCOMES" 478.0 KB 3425 rows
. . imported "MT01"."FLX_EP_ACT_GEN_ATTR_B" 379.5 KB 1939 rows
. . imported "MT01"."FLX_MD_DATA_DEFN" 385.8 KB 1714 rows
. . imported "MT01"."FLX_PC_FIN_INST_CONST_B" 391.6 KB 14066 rows
. . imported "MT01"."FLX_FA_VALUE_DATASOURCES" 323.2 KB 1612 rows
. . imported "MT01"."FLX_LN_ACCT_CONFIG_DTLS_S" 47.44 KB 3 rows
. . imported "MT01"."FLX_PC_FIN_IDENTIFICATION_B" 336.2 KB 14065 rows
. . imported "MT01"."FLX_SM_SERVICE_INP_AUTH_B" 18.01 KB 34 rows
. . imported "MT01"."FLX_EP_ACN_LOG_B" 144.8 KB 42 rows
. . imported "MT01"."FLX_EP_MSG_TMPL_B" 202.0 KB 403 rows
. . imported "MT01"."FLX_RL_RULE_CONDITIONS" 260.4 KB 2118 rows
. . imported "MT01"."FLX_EP_MSG_SRC_B" 203.7 KB 741 rows
. . imported "MT01"."FLX_PI_IND_CLASS" 228.8 KB 4206 rows
. . imported "MT01"."FLX_PI_KYC_VER_DTL_B" 12.88 KB 6 rows
. . imported "MT01"."FLX_PM_PRODUCT_GROUP_FLOW" 31.71 KB 4 rows
. . imported "MT01"."FLX_PR_RCHART_EVAL_TIERS" 248.1 KB 1287 rows
. . imported "MT01"."FLX_SM_UNAPPR_TXN_B" 86.62 KB 2 rows
. . imported "MT01"."FLX_TD_TRANSACTION_STATE" 11.90 KB 3 rows
. . imported "MT01"."FLX_CS_AUDIT_SEARCH_CONTEXT" 121.2 KB 44 rows
. . imported "MT01"."FLX_FA_AGGREGATE_LINKS" 176.7 KB 1804 rows
. . imported "MT01"."FLX_FA_GROUP_XREF" 151.8 KB 2102 rows
. . imported "MT01"."FLX_FA_VALUE_BINDINGS" 201.0 KB 1947 rows
. . imported "MT01"."FLX_IN_LN_SIM_LOG_ITEM" 176.1 KB 684 rows
. . imported "MT01"."FLX_OR_FTT_PM_CODES_XREF" 141.5 KB 11210 rows
. . imported "MT01"."FLX_PM_DOMAIN_CAT_FLOW" 26.80 KB 5 rows
. . imported "MT01"."FLX_PM_PRODUCT_ACCTROLE" 165.1 KB 1238 rows
. . imported "MT01"."FLX_PR_CONSOL_OFF_MAP_B" 177.4 KB 1409 rows
. . imported "MT01"."FLX_RL_RULE_EXECUTION_H" 154.8 KB 1448 rows
. . imported "MT01"."FLX_RL_RULE_EXP_FACT_XRF" 186.0 KB 2313 rows
. . imported "MT01"."FLX_RL_RULE_GEN_OUTCOMES" 196.4 KB 3425 rows
. . imported "MT01"."FLX_RL_RULE_STATEMENTS" 154.0 KB 1473 rows
. . imported "MT01"."FLX_RL_TEMPLATES_ALL_B" 110.0 KB 8 rows
. . imported "MT01"."FLX_ACCOUNT_TXN_AUDIT_ITEM" 101.9 KB 37 rows
. . imported "MT01"."FLX_EP_MSG_ATTR_B" 114.1 KB 2035 rows
. . imported "MT01"."FLX_LN_ACCT_PREF_CONFIG_T" 19.15 KB 6 rows
. . imported "MT01"."FLX_PR_INDEXES_B" 138.7 KB 659 rows
. . imported "MT01"."FLX_PR_INTEREST_OUTCOMES" 107.4 KB 1694 rows
. . imported "MT01"."FLX_PR_OFFER_SET_B" 136.0 KB 1321 rows
. . imported "MT01"."FLX_PR_OFF_ELM_SET_B" 132.4 KB 1357 rows
. . imported "MT01"."FLX_PR_RCHART_TIER_LKUPS" 146.6 KB 2378 rows
. . imported "MT01"."FLX_RL_RULE_ACTIONS" 138.8 KB 1900 rows
............... ( output truncated ) ............
.............................................
. . imported "MT01"."TEMP_TMP_MISMATCH" 0 KB 0 rows
. . imported "MT01"."TEMP_TMP_MISMATCH_1" 0 KB 0 rows
. . imported "MT01"."TEST" 0 KB 0 rows
. . imported "MT01"."TLOGLEVEL" 0 KB 0 rows
. . imported "MT01"."XF_OL_ST_EXT_TXN_XREF_MMDD" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_CM_CH_WORKDAY" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_CM_WORKDAY" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_CO_COMBINE_LOGS_ENTRY" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_CO_MV_BROPTXN_SHELL_ENTRY" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_CO_PR_BROPTXN_SHELL_ENTRY" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DDL_CH122" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DDL_PL002" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DDL_PL006" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DDL_PL009" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DDL_PL010" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DDL_PL011" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DDL_PL013" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DDL_TD102" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DDL_TD104" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DDL_TD126" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DML_CH122" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DML_PL002" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DML_PL006" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DML_PL009" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DML_PL010" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DML_PL011" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DML_PL013" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DML_TD102" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DML_TD104" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DML_TD126" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DT_C_ADDSUB" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DT_C_BEGIN_END_PERD" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DT_SET_EOP_BOP_FLAGS" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_EOD_CHECK_ALL" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_EOD_INITIALIZE" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_EOD_IS_MONTHEND" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_EOD_PROCESS_BROP_LOGS" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_EOD_PROLOGUE" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_EXT_CHK_DAY_HOLIDAY" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_EXT_GET_NEXT_DATE" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_GLVALTXNSET_SHELL_ENTRY" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_GL_INIT_RESTART" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_GL_UPD_RESTART" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_GL_VAL_TXNS_SET" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_INS_OL_INST_DETAIL" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_LN_WR_ACTNS_PROLOGUE_ENTRY" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_OL_CHECK_TRAN" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_OL_CH_UPD_INST_DETAIL" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_OL_CUTOFF_MOVE_TXNLOGS" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_OL_UNSET_CUTOFF" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_PI_GET_MEMOS" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_RJS_INSERT_REC" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_SETDATE_POSTEOD" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_SETDATE_PREEOD" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_ST_EOD" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_ST_EOD_PREPROC" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_ST_EOD_PROLOGUE_ENTRY" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_ST_EOD_SHELL_ENTRY" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_UPD_CASH_POS" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."FLX_AP_DDL_OS02" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."INITIALIZE_HOST" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."PROC_DEPEND" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_BA_PURGE_OL_BOTS_BCL" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_BA_PURGE_SHELL_ENTRY" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_BRING_CASH_FORWARD" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DDL_LCM17" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DDL_LCM18" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DDL_LCM19" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DML_LCM17" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DML_LCM18" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DML_LCM19" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_EXT_SPLIT_LOAN_DTLS" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_GET_NEXT_WORKING_DATE" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_IS_USER_VAULT" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_OL_BATCH_OPERATIONS" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_OL_CALC_DAT_LOG" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_OL_GET_DAT_LOG" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_ST_PURGE" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_TELLER_CASH_FORWARD" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_UPD_BAT_STAT" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_XMIT_CLOSE_BRANCH_BATCH" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_XMIT_CLOSE_TELLER_BATCH" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_XMIT_CLOSE_VAULT_BATCH" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_XMIT_OPEN_BATCH" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DML_LCM06" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."AP_DDL_LCM06" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."FLX_AP_DDL_OS16" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."FLX_AP_DDL_OS23" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"MT01"."FLX_AP_DDL_OS09" created with compilation warnings
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
ORA-39082: Object type ALTER_PROCEDURE:"MT01"."AP_LN_ACCR_GET_PERIOD_END_DATE" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"MT01"."AP_LN_ACCR_MONTH_CROSSOVER" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"MT01"."AP_LN_POP_DRV_AMORTIZATION" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"MT01"."AP_LN_POP_DRV_REDO_TXNS" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"MT01"."AP_LN_WR_ACTIONS" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"MT01"."AP_PC_POP_DRV_REJECT_POLER" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"MT01"."FLX_AP_DML_OS02" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"MT01"."SETDATES" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"MT01"."AP_LN_ACCR_IS_YEAR_CROSSOVER" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"MT01"."FLX_AP_DML_OS23" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"MT01"."FLX_AP_DML_OS09" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"MT01"."AP_OR_POP_DEV_SUB_EXP" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"MT01"."AP_OR_POP_DRV_SUB_EXP" created with compilation warnings
Processing object type SCHEMA_EXPORT/VIEW/VIEW
ORA-39082: Object type VIEW:"MT01"."VWE_CS_HO_ACCT_MODULE_XREF" created with compilation warnings
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
ORA-39082: Object type PACKAGE_BODY:"MT01"."ACPKS" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."ACPKS_POSITION" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PK_AC_GLOBAL" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PK_BA_PURGE" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PK_GLTBGLBAL" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PK_GLTXNPOSTING" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PK_GL_UPDATE" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PK_PI_LN_INTEGRATION" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PK_ST_BOD_SHELL" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PK_VAL_BATCH" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PK_VAL_CLOSE_BATCH" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PLVDATA" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PLVDDD" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PLVFILE" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PLVGEN" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PLVIO" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PLVJOB" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PLVREP" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PLVXMN" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PLV_LOG_IO" created with compilation warnings
ORA-39082: Object type PACKAGE_BODY:"MT01"."PLV_TRACE_IO" created with compilation warnings
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
Job "SYS"."SYS_IMPORT_FULL_01" completed with 120 error(s) at 18:24:32
Please advice me what is the solution for this? what exactly must have been happen that all the pl/sql got converted in UPPERCASE.
Thanks in advance.