Microsoft Windows [version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. Tous droits réservés.
C:\Users\stagiaires> impdp joresenergizer/cnps directory=jorespump dumpfile=jores11.dmp remap_schema=energizer:joresenerizer
Import: Release 11.2.0.2.0 - Beta on Ven. Juin 27 18:05:54 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Beta
Master table "JORESENERGIZER"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "JORESENERGIZER"."SYS_IMPORT_FULL_01": joresenergizer/******** directory=jorespump dumpfile=jores11.dmp remap_schema=energizer:joresene
rizer
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE:"JORESENERIZER"."JASSURE" failed to create with error:
ORA-01918: user 'JORESENERIZER' does not exist
Failing sql is:
CREATE TABLE "JORESENERIZER"."JASSURE" ("NUM_ASSU" VARCHAR2(13 CHAR) NOT NULL ENABLE, "NOM_ASSU" VARCHAR2(60 CHAR), "PRENOM_ASSU" VARCHAR2(60 CHA
R), "DATE_NAISS_ASSU" DATE, "NOM_JEUNE_FILLE_ASSU" VARCHAR2(25 CHAR), "SEXE_ASSU" VARCHAR2(1 CHAR), "CIVILITE_ASSU" VARCHAR2(5 CHAR), "TEL_ASSU"
VARCHAR2(20 CHAR), "FAX_ASSU" VARCHAR2(20 CHAR), "EMAIL_ASSU" VARCHAR2(50
ORA-39083: Object type TABLE:"JORESENERIZER"."TCOMPTE_ASSURE" failed to create with error:
ORA-01918: user 'JORESENERIZER' does not exist
Failing sql is:
CREATE TABLE "JORESENERIZER"."TCOMPTE_ASSURE" ("NUMERO_DIPE" NUMBER(5,0) NOT NULL ENABLE, "NUMERO_CONTRIB" VARCHAR2(20 CHAR) DEFAULT NULL, "MOIS_
DIPE" NUMBER(2,0) NOT NULL ENABLE, "MATRICULE_EMPL" VARCHAR2(17 CHAR) NOT NULL ENABLE, "REGIME" NUMBER(1,0) NOT NULL ENABLE, "ANNEE" NUMBER(4,0)
NOT NULL ENABLE, "MATRICULE_ASS" VARCHAR2(13 BYTE) DEFAULT NULL, "
ORA-39083: Object type TABLE:"JORESENERIZER"."JASSURE_DELETE2" failed to create with error:
ORA-01918: user 'JORESENERIZER' does not exist
Failing sql is:
CREATE TABLE "JORESENERIZER"."JASSURE_DELETE2" ("NUM_ASSU" VARCHAR2(13 CHAR) NOT NULL ENABLE, "NOM_ASSU" VARCHAR2(60 CHAR), "PRENOM_ASSU" VARCHAR
2(60 CHAR), "DATE_NAISS_ASSU" DATE, "NOM_JEUNE_FILLE_ASSU" VARCHAR2(25 CHAR), "SEXE_ASSU" VARCHAR2(1 CHAR), "CIVILITE_ASSU" VARCHAR2(5 CHAR), "TE
L_ASSU" VARCHAR2(20 CHAR), "FAX_ASSU" VARCHAR2(20 CHAR), "EMAIL_A
ORA-39083: Object type TABLE:"JORESENERIZER"."JEMPLOYEUR" failed to create with error:
ORA-01918: user 'JORESENERIZER' does not exist
Failing sql is:
CREATE TABLE "JORESENERIZER"."JEMPLOYEUR" ("NUM_EMPLOYEUR" VARCHAR2(17 CHAR) NOT NULL ENABLE, "RAISON_SOCIALE" VARCHAR2(200 CHAR), "SIGLE" VARCHA
R2(30 CHAR), "ADRESSE_EMPLOYEUR" VARCHAR2(100 CHAR), "BOITE_POSTALE" VARCHAR2(10 CHAR), "TEL" VARCHAR2(30 CHAR), "FAX" VARCHAR2(20 CHAR), "EMAIL"
VARCHAR2(50 CHAR), "CODE_ARROND" VARCHAR2(6 CHAR), "CODE_PAYS" VARCHA
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-20000: INDEX "ERIC_NGAH"."CIRCUIT_DOSSIEREM_FK_IDX" does not exist or insufficient privileges
Failing sql is:
DECLARE I_N VARCHAR2(60); I_O VARCHAR2(60); NV VARCHAR2(1); c DBMS_METADATA.T_VAR_COLL; df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS'; stmt
varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',
6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,
ORA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-20000: INDEX "ERIC_NGAH"."JEMPLOYEUR_LIEUNAISS_IDX" does not exist or insufficient privileges
Failing sql is:
DECLARE I_N VARCHAR2(60); I_O VARCHAR2(60); NV VARCHAR2(1); c DBMS_METADATA.T_VAR_COLL; df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS'; stmt
varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',
6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,
ORA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-20000: INDEX "ERIC_NGAH"."FK_CODENA_JEMPLOYEUR_IDX" does not exist or insufficient privileges
Failing sql is:
DECLARE I_N VARCHAR2(60); I_O VARCHAR2(60); NV VARCHAR2(1); c DBMS_METADATA.T_VAR_COLL; df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS'; stmt
varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',
6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "JORESENERGIZER"."SYS_IMPORT_FULL_01" completed with 7 error(s) at 18:05:58
C:\Users\stagiaires>
Partager