vendredi 30 janvier 2015

oracle11g DB dump importin


I tried to import the oracle11g DB dump but i got below below exception. This command i am using:



impdp USERNAME/Password directory=ks dumpfile=dumpfilename.dmp logfile=logfilename.log table_exists_action=replace


And the output:



Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"NUTRITION_UK1" 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/TYPE/TYPE_SPEC
ORA-31684: Object type TYPE:"NUTRITION_UK1"."NUMBER_NTT" already exists
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
ORA-31684: Object type SEQUENCE:"NUTRITION_UK1"."SEQ_AUDIT_ID" already exists
ORA-31684: Object type SEQUENCE:"NUTRITION_UK1"."SEQ_BUNDLETYPE_IMAGE_ID" already exists
ORA-31684: Object type SEQUENCE:"NUTRITION_UK1"."SEQ_BUNDLE_ID" already exists
ORA-31684: Object type SEQUENCE:"NUTRITION_UK1"."SEQ_BUNDLE_TYPE_ID" already exists
ORA-31684: Object type SEQUENCE:"NUTRITION_UK1"."SEQ_COMPONENT_ID" already exists
ORA-31684: Object type SEQUENCE:"NUTRITION_UK1"."SEQ_IMAGE_ID" already exists
ORA-31684: Object type SEQUENCE:"NUTRITION_UK1"."SEQ_ITEM_ID" already exists
ORA-31684: Object type SEQUENCE:"NUTRITION_UK1"."SEQ_ITEM_MUTEX_ID" already exists
ORA-31684: Object type SEQUENCE:"NUTRITION_UK1"."SEQ_LAST_PUBLISHED_ID" already exists
ORA-31684: Object type SEQUENCE:"NUTRITION_UK1"."SEQ_MENU_SUBSET" already exists
ORA-31684: Object type SEQUENCE:"NUTRITION_UK1"."SEQ_MUL_SIZE_ID" already exists
ORA-31684: Object type SEQUENCE:"NUTRITION_UK1"."SEQ_PRE_DFD_MEAL" already exists
ORA-31684: Object type SEQUENCE:"NUTRITION_UK1"."SEQ_NUMBER" already exists
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "NUTRITION_UK1"."ITEM_301012_BEFORE_PL" 45.41 MB 329 rows
. . imported "NUTRITION_UK1"."ITEM_NEW" 45.76 MB 308 rows
. . imported "NUTRITION_UK1"."ITEM_011112" 43.31 MB 316 rows
. . imported "NUTRITION_UK1"."ITEM_24OCT12" 43.31 MB 313 rows
. . imported "NUTRITION_UK1"."ITEM_311012" 43.31 MB 314 rows
. . imported "NUTRITION_UK1"."AUDIT_TRAIL" 976.3 KB 9044 rows
. . imported "NUTRITION_UK1"."ITEM" 220.6 KB 468 rows
. . imported "NUTRITION_UK1"."ITEM_ALLERGEN" 212.4 KB 6420 rows
. . imported "NUTRITION_UK1"."ITEM_NUTRITION" 124.5 KB 2971 rows
. . imported "NUTRITION_UK1"."COMPONENT" 115.8 KB 307 rows
. . imported "NUTRITION_UK1"."ITEM_COMPONENT" 47.98 KB 1096 rows
. . imported "NUTRITION_UK1"."ITEM_FOOT" 34.20 KB 918 rows
. . imported "NUTRITION_UK1"."ALLERGEN" 7.265 KB 21 rows
. . imported "NUTRITION_UK1"."ALLERGEN_BKP" 7.054 KB 15 rows
. . imported "NUTRITION_UK1"."COUNTRY" 5.445 KB 2 rows
. . imported "NUTRITION_UK1"."FOOD_FACTS" 6.335 KB 7 rows
. . imported "NUTRITION_UK1"."FOOT" 12.13 KB 35 rows
. . imported "NUTRITION_UK1"."FOOT_BKP" 15.54 KB 46 rows
. . imported "NUTRITION_UK1"."ITEM_EMAIL" 5.078 KB 2 rows
. . imported "NUTRITION_UK1"."ITEM_FOOT_BKP" 25.76 KB 637 rows
. . imported "NUTRITION_UK1"."ITEM_IMAGE_SCHEDULER_JOB" 5.039 KB 1 rows
. . imported "NUTRITION_UK1"."ITEM_ITEM_TYPE" 17.28 KB 353 rows
. . imported "NUTRITION_UK1"."ITEM_TYPE" 6.359 KB 3 rows
. . imported "NUTRITION_UK1"."LAST_PUBLISHED" 18.96 KB 348 rows
. . imported "NUTRITION_UK1"."LEGAL" 5.867 KB 3 rows
. . imported "NUTRITION_UK1"."LEGAL_CONTENT" 7.179 KB 3 rows
. . imported "NUTRITION_UK1"."MENU" 7.789 KB 18 rows
. . imported "NUTRITION_UK1"."MENU_GROUP" 5.882 KB 3 rows
. . imported "NUTRITION_UK1"."MENU_GROUP_TO_MENU" 6.195 KB 29 rows
. . imported "NUTRITION_UK1"."MULTIPLE_SIZE_INFO" 11.67 KB 72 rows
. . imported "NUTRITION_UK1"."MULTIPLE_SIZE_ITEM" 11.32 KB 104 rows
. . imported "NUTRITION_UK1"."NUTRITION" 6.953 KB 9 rows
. . imported "NUTRITION_UK1"."NUTRITION_BKP" 6.914 KB 8 rows
. . imported "NUTRITION_UK1"."PUSH_LIVE_DATA" 5.023 KB 1 rows
. . imported "NUTRITION_UK1"."USERS" 6.515 KB 8 rows
. . imported "NUTRITION_UK1"."USER_COUNTRY" 5.531 KB 7 rows
. . imported "NUTRITION_UK1"."ITEM_BK_11082011" 0 KB 0 rows
. . imported "NUTRITION_UK1"."ITEM_IMAGE" 0 KB 0 rows
. . imported "NUTRITION_UK1"."ITEM_ORGINAL" 0 KB 0 rows
. . imported "NUTRITION_UK1"."ITEM_QA" 0 KB 0 rows
. . imported "NUTRITION_UK1"."PROCESS" 0 KB 0 rows
. . imported "NUTRITION_UK1"."QUESTION_ANSWER" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
ORA-31684: Object type FUNCTION:"NUTRITION_UK1"."GET_NEXT_CSEQ" already exists
ORA-31684: Object type FUNCTION:"NUTRITION_UK1"."GROUP_CONCAT_NUMBER" already exists
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
ORA-31684: Object type PROCEDURE:"NUTRITION_UK1"."MI_ALLERGEN" already exists
ORA-31684: Object type PROCEDURE:"NUTRITION_UK1"."MI_MENU_ITEM" already exists
ORA-31684: Object type PROCEDURE:"NUTRITION_UK1"."MI_NUTRITION_DATA" already exists
ORA-31684: Object type PROCEDURE:"NUTRITION_UK1"."PUSH_ALL_DATA" already exists
ORA-31684: Object type PROCEDURE:"NUTRITION_UK1"."REVERT_ALL_COMPONENTS" already exists
ORA-31684: Object type PROCEDURE:"NUTRITION_UK1"."REVERT_ALL_DATA" already exists
ORA-31684: Object type PROCEDURE:"NUTRITION_UK1"."REVERT_SPECIFIC_COMPONENT" already exists
ORA-31684: Object type PROCEDURE:"NUTRITION_UK1"."REVERT_SPECIFIC_ITEMS" already exists
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
ORA-39082: Object type ALTER_PROCEDURE:"NUTRITION_UK1"."MI_ALLERGEN" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"NUTRITION_UK1"."MI_MENU_ITEM" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"NUTRITION_UK1"."MI_NUTRITION_DATA" created with compilation warnings
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/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
**Job "NUTRITION_UK1"."SYS_IMPORT_FULL_01" completed with 28 error(s) at 02:38:40**


Aucun commentaire:

Enregistrer un commentaire