1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
|
oracle@ateq-gl ateqora]$ imp userid=system/manager file=/u02/oradata/ateqora/dump/gl_tbs.dmp log=/u02/oradata/ateqora/dump/imp_gl_tbs.log tablespaces=gl_temp full=y
Import: Release 10.2.0.1.0 - Production on Wed Jun 20 13:56:49 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing SYSTEM's objects into SYSTEM
. importing GL's objects into GL
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "PERSONNES" ("PERS_ID" VARCHAR2(5), "PERS_NOM" VARCHAR2(10), ""
"PERS_PRENOM" VARCHAR2(15), "VOIT_ID" VARCHAR2(5)) PCTFREE 10 PCTUSED 40 IN"
"ITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 B"
"UFFER_POOL DEFAULT) LOGGING NOCOMPRESS"
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "TEST" ("ID" NUMBER(2, 0), "TEXTE" VARCHAR2(10)) PCTFREE 10 P"
"CTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIS"
"T GROUPS 1 BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS"
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "VOITURES" ("VOIT_ID" VARCHAR2(5), "MARQUE" VARCHAR2(10), "TYP"
"E" VARCHAR2(15), "PUISSANCE" NUMBER(3, 0)) PCTFREE 10 PCTUSED 40 INITRANS "
"1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_P"
"OOL DEFAULT) LOGGING NOCOMPRESS"
Import terminated successfully with warnings. |
Partager