-
Import Problem
While importing the datas from production to test user .
The datas imported and in log file I found these errors.
It seems to be problem with triggers.
Pl. let us know what may be problem and how do solve this
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_ADDRESS1_"
"LK_SA_LOCATION"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_ADDRESS1_LK_SA_LOCATION does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_ADDRESS2_"
"LK_SA_LOCATION"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_ADDRESS2_LK_SA_LOCATION does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_ADDRESS3_"
"LK_SA_LOCATION"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_ADDRESS3_LK_SA_LOCATION does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_ADJ_NAME_"
"LK_SA_ADJ"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_ADJ_NAME_LK_SA_ADJ does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_ADJ_NAME_"
"LK_SA_PRE_ADJ"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_ADJ_NAME_LK_SA_PRE_ADJ does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_ALIAS_LK_"
"SA_USER"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_ALIAS_LK_SA_USER does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_AMOUNT"',"
" FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_AMOUNT does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_AREA_NAME"
"_LK_SA_COVERAGE"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_AREA_NAME_LK_SA_COVERAGE does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_CATEGORY_"
"NAME_LK_SA_PROD"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_CATEGORY_NAME_LK_SA_PROD does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_CITY_LK_E"
"N_COVERAGE_CITY"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_CITY_LK_SA_COVERAGE_CITY does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_CITY_LK_E"
"N_LOCATION"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_CITY_LK_SA_LOCATION does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_COMPANY_A"
"LIAS_NAME_LK_EN"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_COMPANY_ALIAS_NAME_LK_EN does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_COMPANY_I"
"D_LK_SA_COMPANY"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_COMPANY_ID_LK_SA_COMPANY does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_COMPANY_N"
"AME_LK_SA_COMPA"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_COMPANY_NAME_LK_SA_COMPA does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_CONTENT_N"
"AME_LK_SA_CONTE"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_CONTENT_NAME_LK_SA_CONTE does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_CONTRACT_"
"ID_LK_SA_CONTRA"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_CONTRACT_ID_LK_SA_CONTRA does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23308:
"BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('TEST42-MS1', '"BI_BU_COUNTRY_N"
"AME_LK_SA_COUNT"', FALSE); END;"
IMP-00003: ORACLE error 23308 TESTountered
ORA-23308: object TEST42.BI_BU_COUNTRY_NAME_LK_SA_COUNT does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_DDL_INTERNAL", line 41
ORA-06512: at "SYS.DBMS_DDL", line 255
ORA-06512: at line 1
-
well do those objects exist - the ones it is complaining about?
-
Hi
For your information the data taken from
From user : 8i user is TEST42-MS1
To User : 9i user is TEST42_NEW
pl. let us know is there any version compatibilty
if so, how to recify it
-
ill repeat"well do those objects exist - the ones it is complaining about?"
-
Maybe the problem is because the name of the objects contains the schema owner?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|