· 8 years ago · Nov 18, 2017, 08:02 PM
1Microsoft Windows [Versión 10.0.15063]
2(c) 2017 Microsoft Corporation. Todos los derechos reservados.
3
4C:\Users\Christopher Elias>ipconfig
5
6Configuración IP de Windows
7
8
9Adaptador de Ethernet Ethernet:
10
11 Estado de los medios. . . . . . . . . . . : medios desconectados
12 Sufijo DNS especÃfico para la conexión. . :
13
14Adaptador de LAN inalámbrica Conexión de área local* 3:
15
16 Estado de los medios. . . . . . . . . . . : medios desconectados
17 Sufijo DNS especÃfico para la conexión. . :
18
19Adaptador de LAN inalámbrica Wi-Fi:
20
21 Sufijo DNS especÃfico para la conexión. . :
22 VÃnculo: dirección IPv6 local. . . : fe80::c049:a371:c20f:438e%14
23 Dirección IPv4. . . . . . . . . . . . . . : 192.168.0.105
24 Máscara de subred . . . . . . . . . . . . : 255.255.255.0
25 Puerta de enlace predeterminada . . . . . : 192.168.0.1
26
27Adaptador de Ethernet Conexión de red Bluetooth:
28
29 Estado de los medios. . . . . . . . . . . : medios desconectados
30 Sufijo DNS especÃfico para la conexión. . :
31
32Adaptador de túnel Conexión de área local* 13:
33
34 Sufijo DNS especÃfico para la conexión. . :
35 Dirección IPv6 . . . . . . . . . . : 2001:0:5ef5:79fd:282a:c81e:4117:b97d
36 VÃnculo: dirección IPv6 local. . . : fe80::282a:c81e:4117:b97d%17
37 Puerta de enlace predeterminada . . . . . : ::
38
39C:\Users\Christopher Elias> impdp uciadmin dumpfile=data-dmp.DMP logfile=IMPCOPIA.log directory=ORACLEBKPDB full=y
40
41Import: Release 11.2.0.2.0 - Production on Sßb Nov 18 13:11:44 2017
42
43Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
44Password:
45
46Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
47ORA-39002: invalid operation
48ORA-39070: Unable to open the log file.
49ORA-39087: directory name ORACLEBKPDB is invalid
50
51
52
53C:\Users\Christopher Elias> impdp uciadmin dumpfile=data-dmp.DMP logfile=IMPCOPIA.log directory=BKP full=y
54
55Import: Release 11.2.0.2.0 - Production on Sßb Nov 18 13:12:44 2017
56
57Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
58Password:
59
60Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
61ORA-39002: invalid operation
62ORA-39070: Unable to open the log file.
63ORA-39087: directory name BKP is invalid
64
65
66
67C:\Users\Christopher Elias>impdp uciadmin file=D:\BKP\data-dmp.DMP full=y logfile=IMPCOPIA.log
68
69Import: Release 11.2.0.2.0 - Production on Sßb Nov 18 13:14:18 2017
70
71Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
72Password:
73
74Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
75ORA-39002: invalid operation
76ORA-39070: Unable to open the log file.
77ORA-39145: directory object parameter must be specified and non-null
78
79
80
81C:\Users\Christopher Elias>impdp uciadmin file=D:\BKP\data-dmp.DMP FULL=y logfile=log_file.log
82
83Import: Release 11.2.0.2.0 - Production on Sßb Nov 18 13:15:33 2017
84
85Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
86Password:
87
88Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
89ORA-39002: invalid operation
90ORA-39070: Unable to open the log file.
91ORA-39145: directory object parameter must be specified and non-null
92
93
94
95C:\Users\Christopher Elias>impdp uciadmin file=D:\BKP\data-dmp.DMP FULL=y log=log_file.log
96
97Import: Release 11.2.0.2.0 - Production on Sßb Nov 18 13:16:01 2017
98
99Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
100Password:
101
102Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
103ORA-39002: invalid operation
104ORA-39070: Unable to open the log file.
105ORA-39145: directory object parameter must be specified and non-null
106
107
108
109C:\Users\Christopher Elias>impdp uciadmin file=D:\BKP\data-dmp.DMP FULL=y
110
111Import: Release 11.2.0.2.0 - Production on Sßb Nov 18 13:16:27 2017
112
113Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
114Password:
115
116Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
117ORA-39001: invalid argument value
118ORA-39000: bad dump file specification
119ORA-39088: file name cannot contain a path specification
120
121
122
123C:\Users\Christopher Elias>impdp uciadmin file=D:\BKP\bak.dmp FULL=y
124
125Import: Release 11.2.0.2.0 - Production on Sßb Nov 18 13:17:08 2017
126
127Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
128Password:
129
130Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
131ORA-39001: invalid argument value
132ORA-39000: bad dump file specification
133ORA-39088: file name cannot contain a path specification
134
135
136
137C:\Users\Christopher Elias>imp uciadmin file=D:\BKP\bak.dmp FULL=y
138
139Import: Release 11.2.0.2.0 - Production on Sßb Nov 18 13:18:32 2017
140
141Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
142
143Password:
144
145Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
146
147Export file created by EXPORT:V11.02.00 via conventional path
148
149Warning: the objects were exported by UCIUCIN, not by you
150
151import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
152import server uses AL32UTF8 character set (possible charset conversion)
153. importing UCIUCIN's objects into UCIADMIN
154IMP-00015: following statement failed because the object already exists:
155 "CREATE SEQUENCE "DEMO_CUST_SEQ" MINVALUE 1 MAXVALUE 99999999999999999999999"
156 "99999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE"
157IMP-00015: following statement failed because the object already exists:
158 "CREATE SEQUENCE "DEMO_ORDER_ITEMS_SEQ" MINVALUE 1 MAXVALUE 9999999999999999"
159 "999999999999 INCREMENT BY 1 START WITH 61 CACHE 20 NOORDER NOCYCLE"
160IMP-00015: following statement failed because the object already exists:
161 "CREATE SEQUENCE "DEMO_ORD_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999"
162 "9999 INCREMENT BY 1 START WITH 11 CACHE 20 NOORDER NOCYCLE"
163IMP-00015: following statement failed because the object already exists:
164 "CREATE SEQUENCE "DEMO_PROD_SEQ" MINVALUE 1 MAXVALUE 99999999999999999999999"
165 "99999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE"
166IMP-00015: following statement failed because the object already exists:
167 "CREATE SEQUENCE "DEMO_USERS_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999"
168 "999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE"
169IMP-00015: following statement failed because the object already exists:
170 "CREATE TABLE "APEX$_ACL" ("ID" NUMBER NOT NULL ENABLE, "WS_APP_ID" NUMBER N"
171 "OT NULL ENABLE, "USERNAME" VARCHAR2(255) NOT NULL ENABLE, "PRIV" VARCHAR2(1"
172 ") NOT NULL ENABLE, "CREATED_ON" DATE NOT NULL ENABLE, "CREATED_BY" VARCHAR2"
173 "(255) NOT NULL ENABLE, "UPDATED_ON" DATE, "UPDATED_BY" VARCHAR2(255)) PCTF"
174 "REE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 104857"
175 "6 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
176 " LOGGING NOCOMPRESS"
177IMP-00015: following statement failed because the object already exists:
178 "CREATE TABLE "APEX$_WS_FILES" ("ID" NUMBER, "WS_APP_ID" NUMBER NOT NULL ENA"
179 "BLE, "DATA_GRID_ID" NUMBER, "ROW_ID" NUMBER, "WEBPAGE_ID" NUMBER, "COMPONEN"
180 "T_LEVEL" VARCHAR2(30), "NAME" VARCHAR2(255) NOT NULL ENABLE, "IMAGE_ALIAS" "
181 "VARCHAR2(255), "IMAGE_ATTRIBUTES" VARCHAR2(255), "CONTENT" BLOB, "CONTENT_L"
182 "AST_UPDATE" DATE, "MIME_TYPE" VARCHAR2(255) NOT NULL ENABLE, "CONTENT_CHARS"
183 "ET" VARCHAR2(255), "CONTENT_FILENAME" VARCHAR2(500), "DESCRIPTION" VARCHAR2"
184 "(4000), "CREATED_ON" DATE NOT NULL ENABLE, "CREATED_BY" VARCHAR2(255) NOT N"
185 "ULL ENABLE, "UPDATED_ON" DATE, "UPDATED_BY" VARCHAR2(255)) PCTFREE 10 PCTU"
186 "SED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENT"
187 "S 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" L"
188 "OGGING NOCOMPRESS LOB ("CONTENT") STORE AS BASICFILE (TABLESPACE "USERS" E"
189 "NABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE(INITIAL"
190 " 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL "
191 "DEFAULT))"
192IMP-00015: following statement failed because the object already exists:
193 "CREATE TABLE "APEX$_WS_HISTORY" ("ROW_ID" NUMBER NOT NULL ENABLE, "WS_APP_I"
194 "D" NUMBER NOT NULL ENABLE, "DATA_GRID_ID" NUMBER NOT NULL ENABLE, "COLUMN_N"
195 "AME" VARCHAR2(255), "OLD_VALUE" VARCHAR2(4000), "NEW_VALUE" VARCHAR2(4000),"
196 " "APPLICATION_USER_ID" VARCHAR2(255), "CHANGE_DATE" DATE) PCTFREE 10 PCTUS"
197 "ED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS"
198 " 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) LO"
199 "GGING NOCOMPRESS"
200IMP-00015: following statement failed because the object already exists:
201 "CREATE TABLE "APEX$_WS_LINKS" ("ID" NUMBER, "WS_APP_ID" NUMBER NOT NULL ENA"
202 "BLE, "DATA_GRID_ID" NUMBER, "ROW_ID" NUMBER, "WEBPAGE_ID" NUMBER, "COMPONEN"
203 "T_LEVEL" VARCHAR2(30), "TAGS" VARCHAR2(4000), "SHOW_ON_HOMEPAGE" VARCHAR2(1"
204 "), "LINK_NAME" VARCHAR2(255) NOT NULL ENABLE, "URL" VARCHAR2(4000) NOT NULL"
205 " ENABLE, "LINK_DESCRIPTION" VARCHAR2(4000), "DISPLAY_SEQUENCE" NUMBER, "CRE"
206 "ATED_ON" DATE NOT NULL ENABLE, "CREATED_BY" VARCHAR2(255) NOT NULL ENABLE, "
207 ""UPDATED_ON" DATE, "UPDATED_BY" VARCHAR2(255)) PCTFREE 10 PCTUSED 40 INITR"
208 "ANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELIST"
209 "S 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) LOGGING NOCOM"
210 "PRESS"
211IMP-00015: following statement failed because the object already exists:
212 "CREATE TABLE "APEX$_WS_NOTES" ("ID" NUMBER, "WS_APP_ID" NUMBER NOT NULL ENA"
213 "BLE, "DATA_GRID_ID" NUMBER, "ROW_ID" NUMBER, "WEBPAGE_ID" NUMBER, "COMPONEN"
214 "T_LEVEL" VARCHAR2(30), "CONTENT" CLOB, "CREATED_ON" DATE NOT NULL ENABLE, ""
215 "CREATED_BY" VARCHAR2(255) NOT NULL ENABLE, "UPDATED_ON" DATE, "UPDATED_BY" "
216 "VARCHAR2(255)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITI"
217 "AL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POO"
218 "L DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS LOB ("CONTENT") STORE AS B"
219 "ASICFILE (TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION N"
220 "OCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1"
221 " FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
222IMP-00015: following statement failed because the object already exists:
223 "CREATE TABLE "APEX$_WS_ROWS" ("ID" NUMBER NOT NULL ENABLE, "WS_APP_ID" NUMB"
224 "ER NOT NULL ENABLE, "DATA_GRID_ID" NUMBER NOT NULL ENABLE, "UNIQUE_VALUE" V"
225 "ARCHAR2(255), "TAGS" VARCHAR2(4000), "PARENT_ROW_ID" NUMBER, "OWNER" VARCHA"
226 "R2(255), "GEOCODE" VARCHAR2(512), "LOAD_ORDER" NUMBER, "CHANGE_COUNT" NUMBE"
227 "R, "CREATED_ON" DATE NOT NULL ENABLE, "CREATED_BY" VARCHAR2(255) NOT NULL E"
228 "NABLE, "UPDATED_ON" DATE, "UPDATED_BY" VARCHAR2(255), "C001" VARCHAR2(4000)"
229 ", "C002" VARCHAR2(4000), "C003" VARCHAR2(4000), "C004" VARCHAR2(4000), "C00"
230 "5" VARCHAR2(4000), "C006" VARCHAR2(4000), "C007" VARCHAR2(4000), "C008" VAR"
231 "CHAR2(4000), "C009" VARCHAR2(4000), "C010" VARCHAR2(4000), "C011" VARCHAR2("
232 "4000), "C012" VARCHAR2(4000), "C013" VARCHAR2(4000), "C014" VARCHAR2(4000),"
233 " "C015" VARCHAR2(4000), "C016" VARCHAR2(4000), "C017" VARCHAR2(4000), "C018"
234 "" VARCHAR2(4000), "C019" VARCHAR2(4000), "C020" VARCHAR2(4000), "C021" VARC"
235 "HAR2(4000), "C022" VARCHAR2(4000), "C023" VARCHAR2(4000), "C024" VARCHAR2(4"
236 "000), "C025" VARCHAR2(4000), "C026" VARCHAR2(4000), "C027" VARCHAR2(4000), "
237 ""C028" VARCHAR2(4000), "C029" VARCHAR2(4000), "C030" VARCHAR2(4000), "C031""
238 " VARCHAR2(4000), "C032" VARCHAR2(4000), "C033" VARCHAR2(4000), "C034" VARCH"
239 "AR2(4000), "C035" VARCHAR2(4000), "C036" VARCHAR2(4000), "C037" VARCHAR2(40"
240 "00), "C038" VARCHAR2(4000), "C039" VARCHAR2(4000), "C040" VARCHAR2(4000), ""
241 "C041" VARCHAR2(4000), "C042" VARCHAR2(4000), "C043" VARCHAR2(4000), "C044" "
242 "VARCHAR2(4000), "C045" VARCHAR2(4000), "C046" VARCHAR2(4000), "C047" VARCHA"
243 "R2(4000), "C048" VARCHAR2(4000), "C049" VARCHAR2(4000), "C050" VARCHAR2(400"
244 "0), "N001" NUMBER, "N002" NUMBER, "N003" NUMBER, "N004" NUMBER, "N005" NUMB"
245 "ER, "N006" NUMBER, "N007" NUMBER, "N008" NUMBER, "N009" NUMBER, "N010" NUMB"
246 "ER, "N011" NUMBER, "N012" NUMBER, "N013" NUMBER, "N014" NUMBER, "N015" NUMB"
247 "ER, "N016" NUMBER, "N017" NUMBER, "N018" NUMBER, "N019" NUMBER, "N020" NUMB"
248 "ER, "N021" NUMBER, "N022" NUMBER, "N023" NUMBER, "N024" NUMBER, "N025" NUMB"
249 "ER, "N026" NUMBER, "N027" NUMBER, "N028" NUMBER, "N029" NUMBER, "N030" NUMB"
250 "ER, "N031" NUMBER, "N032" NUMBER, "N033" NUMBER, "N034" NUMBER, "N035" NUMB"
251 "ER, "N036" NUMBER, "N037" NUMBER, "N038" NUMBER, "N039" NUMBER, "N040" NUMB"
252 "ER, "N041" NUMBER, "N042" NUMBER, "N043" NUMBER, "N044" NUMBER, "N045" NUMB"
253 "ER, "N046" NUMBER, "N047" NUMBER, "N048" NUMBER, "N049" NUMBER, "N050" NUMB"
254 "ER, "D001" DATE, "D002" DATE, "D003" DATE, "D004" DATE, "D005" DATE, "D006""
255 " DATE, "D007" DATE, "D008" DATE, "D009" DATE, "D010" DATE, "D011" DATE, "D0"
256 "12" DATE, "D013" DATE, "D014" DATE, "D015" DATE, "D016" DATE, "D017" DATE, "
257 ""D018" DATE, "D019" DATE, "D020" DATE, "D021" DATE, "D022" DATE, "D023" DAT"
258 "E, "D024" DATE, "D025" DATE, "D026" DATE, "D027" DATE, "D028" DATE, "D029" "
259 "DATE, "D030" DATE, "D031" DATE, "D032" DATE, "D033" DATE, "D034" DATE, "D03"
260 "5" DATE, "D036" DATE, "D037" DATE, "D038" DATE, "D039" DATE, "D040" DATE, ""
261 "D041" DATE, "D042" DATE, "D043" DATE, "D044" DATE, "D045" DATE, "D046" DATE"
262 ", "D047" DATE, "D048" DATE, "D049" DATE, "D050" DATE, "CLOB001" CLOB, "SEAR"
263 "CH_CLOB" CLOB) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITI"
264 "AL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POO"
265 "L DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS LOB ("CLOB001") STORE AS B"
266 "ASICFILE (TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION N"
267 "OCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1"
268 " FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB ("SEARCH_CLOB") STORE AS BASIC"
269 "FILE (TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCAC"
270 "HE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FRE"
271 "ELIST GROUPS 1 BUFFER_POOL DEFAULT))"
272IMP-00015: following statement failed because the object already exists:
273 "CREATE TABLE "APEX$_WS_TAGS" ("ID" NUMBER, "WS_APP_ID" NUMBER NOT NULL ENAB"
274 "LE, "DATA_GRID_ID" NUMBER, "ROW_ID" NUMBER, "WEBPAGE_ID" NUMBER, "COMPONENT"
275 "_LEVEL" VARCHAR2(30), "TAG" VARCHAR2(4000), "CREATED_ON" DATE NOT NULL ENAB"
276 "LE, "CREATED_BY" VARCHAR2(255) NOT NULL ENABLE, "UPDATED_ON" DATE, "UPDATED"
277 "_BY" VARCHAR2(255)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE("
278 "INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFE"
279 "R_POOL DEFAULT) LOGGING NOCOMPRESS"
280IMP-00015: following statement failed because the object already exists:
281 "CREATE TABLE "APEX$_WS_WEBPG_SECTION_HISTORY" ("SECTION_ID" NUMBER NOT NULL"
282 " ENABLE, "WS_APP_ID" NUMBER NOT NULL ENABLE, "WEBPAGE_ID" NUMBER NOT NULL E"
283 "NABLE, "OLD_DISPLAY_SEQUENCE" NUMBER, "NEW_DISPLAY_SEQUENCE" NUMBER, "OLD_T"
284 "ITLE" VARCHAR2(4000), "NEW_TITLE" VARCHAR2(4000), "OLD_CONTENT" CLOB, "NEW_"
285 "CONTENT" CLOB, "APPLICATION_USER_ID" VARCHAR2(255) NOT NULL ENABLE, "CHANGE"
286 "_DATE" DATE NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255"
287 " STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUP"
288 "S 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS LOB ("OLD_CO"
289 "NTENT") STORE AS BASICFILE (TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK"
290 " 8192 RETENTION NOCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXT"
291 "ENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB ("NEW_CONTEN"
292 "T") STORE AS BASICFILE (TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 819"
293 "2 RETENTION NOCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS"
294 " 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
295IMP-00015: following statement failed because the object already exists:
296 "CREATE TABLE "APEX$_WS_WEBPG_SECTIONS" ("ID" NUMBER NOT NULL ENABLE, "WS_AP"
297 "P_ID" NUMBER NOT NULL ENABLE, "WEBPAGE_ID" NUMBER, "DISPLAY_SEQUENCE" NUMBE"
298 "R, "SECTION_TYPE" VARCHAR2(30) NOT NULL ENABLE, "TITLE" VARCHAR2(4000), "CO"
299 "NTENT" CLOB, "CONTENT_UPPER" CLOB, "NAV_START_WEBPAGE_ID" NUMBER, "NAV_MAX_"
300 "LEVEL" NUMBER, "NAV_INCLUDE_LINK" VARCHAR2(1), "DATA_GRID_ID" NUMBER, "REPO"
301 "RT_ID" NUMBER, "DATA_SECTION_STYLE" NUMBER, "CHART_TYPE" VARCHAR2(255), "CH"
302 "ART_3D" VARCHAR2(1), "CHART_LABEL" VARCHAR2(255), "LABEL_AXIS_TITLE" VARCHA"
303 "R2(255), "CHART_VALUE" VARCHAR2(255), "VALUE_AXIS_TITLE" VARCHAR2(255), "CH"
304 "ART_AGGREGATE" VARCHAR2(255), "CHART_SORTING" VARCHAR2(255), "CREATED_ON" D"
305 "ATE NOT NULL ENABLE, "CREATED_BY" VARCHAR2(255) NOT NULL ENABLE, "UPDATED_O"
306 "N" DATE, "UPDATED_BY" VARCHAR2(255)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXT"
307 "RANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELI"
308 "ST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS LOB "
309 "("CONTENT") STORE AS BASICFILE (TABLESPACE "USERS" ENABLE STORAGE IN ROW C"
310 "HUNK 8192 RETENTION NOCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MI"
311 "NEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) LOB ("CONTEN"
312 "T_UPPER") STORE AS BASICFILE (TABLESPACE "USERS" ENABLE STORAGE IN ROW CHU"
313 "NK 8192 RETENTION NOCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINE"
314 "XTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
315. . importing table "AUXILIAR" 1 rows imported
316IMP-00015: following statement failed because the object already exists:
317 "CREATE TABLE "DEMO_CUSTOMERS" ("CUSTOMER_ID" NUMBER NOT NULL ENABLE, "CUST_"
318 "FIRST_NAME" VARCHAR2(20) NOT NULL ENABLE, "CUST_LAST_NAME" VARCHAR2(20) NOT"
319 " NULL ENABLE, "CUST_STREET_ADDRESS1" VARCHAR2(60), "CUST_STREET_ADDRESS2" V"
320 "ARCHAR2(60), "CUST_CITY" VARCHAR2(30), "CUST_STATE" VARCHAR2(2), "CUST_POST"
321 "AL_CODE" VARCHAR2(10), "PHONE_NUMBER1" VARCHAR2(25), "PHONE_NUMBER2" VARCHA"
322 "R2(25), "CREDIT_LIMIT" NUMBER(9, 2), "CUST_EMAIL" VARCHAR2(30)) PCTFREE 10"
323 " PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINE"
324 "XTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
325 " LOGGING NOCOMPRESS"
326IMP-00015: following statement failed because the object already exists:
327 "CREATE TABLE "DEMO_ORDER_ITEMS" ("ORDER_ITEM_ID" NUMBER(3, 0) NOT NULL ENAB"
328 "LE, "ORDER_ID" NUMBER NOT NULL ENABLE, "PRODUCT_ID" NUMBER NOT NULL ENABLE,"
329 " "UNIT_PRICE" NUMBER(8, 2) NOT NULL ENABLE, "QUANTITY" NUMBER(8, 0) NOT NUL"
330 "L ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65"
331 "536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEF"
332 "AULT) LOGGING NOCOMPRESS"
333IMP-00015: following statement failed because the object already exists:
334 "CREATE TABLE "DEMO_ORDERS" ("ORDER_ID" NUMBER NOT NULL ENABLE, "CUSTOMER_ID"
335 "" NUMBER NOT NULL ENABLE, "ORDER_TOTAL" NUMBER(8, 2), "ORDER_TIMESTAMP" DAT"
336 "E, "USER_ID" NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE"
337 "(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFF"
338 "ER_POOL DEFAULT) LOGGING NOCOMPRESS"
339IMP-00015: following statement failed because the object already exists:
340 "CREATE TABLE "DEMO_PRODUCT_INFO" ("PRODUCT_ID" NUMBER NOT NULL ENABLE, "PRO"
341 "DUCT_NAME" VARCHAR2(50), "PRODUCT_DESCRIPTION" VARCHAR2(2000), "CATEGORY" V"
342 "ARCHAR2(30), "PRODUCT_AVAIL" VARCHAR2(1), "LIST_PRICE" NUMBER(8, 2), "PRODU"
343 "CT_IMAGE" BLOB, "MIMETYPE" VARCHAR2(255), "FILENAME" VARCHAR2(400), "IMAGE_"
344 "LAST_UPDATE" DATE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(I"
345 "NITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER"
346 "_POOL DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS LOB ("PRODUCT_IMAGE") "
347 "STORE AS BASICFILE (TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 RE"
348 "TENTION NOCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 F"
349 "REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
350IMP-00015: following statement failed because the object already exists:
351 "CREATE TABLE "DEMO_STATES" ("ST" VARCHAR2(30), "STATE_NAME" VARCHAR2(30)) "
352 "PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 10"
353 "48576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
354 " LOGGING NOCOMPRESS"
355IMP-00015: following statement failed because the object already exists:
356 "CREATE TABLE "DEMO_USERS" ("USER_ID" NUMBER, "USER_NAME" VARCHAR2(100), "PA"
357 "SSWORD" VARCHAR2(4000), "CREATED_ON" DATE, "QUOTA" NUMBER, "PRODUCTS" CHAR("
358 "1), "EXPIRES_ON" DATE, "ADMIN_USER" CHAR(1)) PCTFREE 10 PCTUSED 40 INITRAN"
359 "S 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS "
360 "1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) LOGGING NOCOMPR"
361 "ESS"
362IMP-00015: following statement failed because the object already exists:
363 "CREATE TABLE "DEPT" ("DEPTNO" NUMBER(2, 0), "DNAME" VARCHAR2(14), "LOC" VAR"
364 "CHAR2(13)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 6"
365 "5536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DE"
366 "FAULT) LOGGING NOCOMPRESS"
367IMP-00015: following statement failed because the object already exists:
368 "CREATE TABLE "EMP" ("EMPNO" NUMBER(4, 0) NOT NULL ENABLE, "ENAME" VARCHAR2("
369 "10), "JOB" VARCHAR2(9), "MGR" NUMBER(4, 0), "HIREDATE" DATE, "SAL" NUMBER(7"
370 ", 2), "COMM" NUMBER(7, 2), "DEPTNO" NUMBER(2, 0)) PCTFREE 10 PCTUSED 40 IN"
371 "ITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREEL"
372 "ISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) LOGGING NO"
373 "COMPRESS"
374. . importing table "MD_ADDITIONAL_PROPERTIES" 0 rows imported
375. . importing table "MD_APPLICATIONFILES" 0 rows imported
376. . importing table "MD_APPLICATIONS" 0 rows imported
377. . importing table "MD_CATALOGS" 0 rows imported
378. . importing table "MD_CODE_REGEX" 5 rows imported
379. . importing table "MD_COLUMNS" 0 rows imported
380. . importing table "MD_CONNECTIONS" 0 rows imported
381. . importing table "MD_CONSTRAINT_DETAILS" 0 rows imported
382. . importing table "MD_CONSTRAINTS" 0 rows imported
383. . importing table "MD_DERIVATIVES" 0 rows imported
384. . importing table "MD_FILE_ARTIFACTS" 0 rows imported
385. . importing table "MD_GROUP_MEMBERS" 0 rows imported
386. . importing table "MD_GROUP_PRIVILEGES" 0 rows imported
387. . importing table "MD_GROUPS" 0 rows imported
388. . importing table "MD_INDEX_DETAILS" 0 rows imported
389. . importing table "MD_INDEXES" 0 rows imported
390. . importing table "MD_MIGR_DEPENDENCY" 0 rows imported
391. . importing table "MD_MIGR_PARAMETER" 0 rows imported
392. . importing table "MD_MIGR_WEAKDEP" 0 rows imported
393. . importing table "MD_NUMROW$SOURCE" 0 rows imported
394. . importing table "MD_NUMROW$TARGET" 0 rows imported
395. . importing table "MD_OTHER_OBJECTS" 0 rows imported
396. . importing table "MD_PACKAGES" 0 rows imported
397. . importing table "MD_PARTITIONS" 0 rows imported
398. . importing table "MD_PRIVILEGES" 0 rows imported
399. . importing table "MD_PROJECTS" 0 rows imported
400. . importing table "MD_REGISTRY" 0 rows imported
401. . importing table "MD_REPOVERSIONS" 0 rows imported
402. . importing table "MD_SCHEMAS" 0 rows imported
403. . importing table "MD_SEQUENCES" 0 rows imported
404. . importing table "MD_STORED_PROGRAMS" 0 rows imported
405. . importing table "MD_SYNONYMS" 0 rows imported
406. . importing table "MD_TABLES" 0 rows imported
407. . importing table "MD_TABLESPACES" 0 rows imported
408. . importing table "MD_TRIGGERS" 0 rows imported
409. . importing table "MD_USER_DEFINED_DATA_TYPES" 0 rows imported
410. . importing table "MD_USER_PRIVILEGES" 0 rows imported
411. . importing table "MD_USERS" 0 rows imported
412. . importing table "MD_VIEWS" 0 rows imported
413. . importing table "MIGR_DATATYPE_TRANSFORM_MAP" 0 rows imported
414. . importing table "MIGR_DATATYPE_TRANSFORM_RULE" 0 rows imported
415. . importing table "MIGR_GENERATION_ORDER" 0 rows imported
416. . importing table "MIGRLOG" 0 rows imported
417. . importing table "STAGE_MIGRLOG" 0 rows imported
418. . importing table "TEST1" 103 rows imported
419. . importing table "TT" 5 rows imported
420. . importing table "UCI_ACTIVIDAD_SERVICIO" 4 rows imported
421. . importing table "UCI_ALMACEN" 1 rows imported
422. . importing table "UCI_ALMACEN_MATERIAL" 3 rows imported
423. . importing table "UCI_ANOTACION" 14 rows imported
424. . importing table "UCI_ANOTACION_DETALLE" 14 rows imported
425. . importing table "UCI_APLICACION_MEDICAMENTO" 25 rows imported
426. . importing table "UCI_ATENCION" 1019 rows imported
427. . importing table "UCI_ATENCION_CLINICA" 0 rows imported
428. . importing table "UCI_ATENCION_DIAGNOSTICO" 1 rows imported
429. . importing table "UCI_ATENCION_DISPOSITIVO" 442 rows imported
430. . importing table "UCI_ATENCION_INGRESO" 105 rows imported
431. . importing table "UCI_ATENCION_INTERVENCION" 5 rows imported
432. . importing table "UCI_ATENCION_MEDICA" 191 rows imported
433. . importing table "UCI_ATENCION_MEDICA_CLINICA" 4448 rows imported
434. . importing table "UCI_ATENCION_MEDICA_DIAG" 233 rows imported
435. . importing table "UCI_ATENCION_OBJETIVO" 6 rows imported
436. . importing table "UCI_ATENCION_PROC_ACTIVIDAD" 165 rows imported
437. . importing table "UCI_ATENCION_PROCED_ACTIVIDAD" 0 rows imported
438. . importing table "UCI_ATENCION_PROCEDIMIENTO" 92 rows imported
439. . importing table "UCI_ATENCION_PROCED_MONITOREO" 68 rows imported
440. . importing table "UCI_ATENCION_PROC_VARIABLE" 117 rows imported
441. . importing table "UCI_ATENCION_SIGNO_VITAL" 1190 rows imported
442. . importing table "UCI_ATENCION_VALORACION" 4032 rows imported
443. . importing table "UCI_CENTRO_ASISTENCIAL" 1 rows imported
444. . importing table "UCI_DIAGNOSTICO" 199 rows imported
445. . importing table "UCI_DIAGNOSTICO_ENFERMERIA" 241 rows imported
446. . importing table "UCI_DOCUMENTO" 1965 rows imported
447. . importing table "UCI_DOCUMENTO_PROCEDIMIENTO" 99 rows imported
448. . importing table "UCI_DOCUMENTO_PROCEDIMIENTO_TI" 238 rows imported
449. . importing table "UCI_EPICRISIS" 12 rows imported
450. . importing table "UCI_EPICRISIS_PROBLEMA" 0 rows imported
451. . importing table "UCI_ESTRUCTURA_CENTRO" 30 rows imported
452. . importing table "UCI_ESTRUCTURA_DOCUMENTO" 91 rows imported
453. . importing table "UCI_ESTRUCTURA_DOCUMENTO_DET" 344 rows imported
454. . importing table "UCI_IMAGEN_UBICACION" 7 rows imported
455. . importing table "UCI_INDICADOR_PUNTAJE" 98 rows imported
456. . importing table "UCI_INTERCONSULTA" 105 rows imported
457. . importing table "UCI_INTERVENCION" 554 rows imported
458. . importing table "UCI_MAESTRO_TIPO" 882 rows imported
459. . importing table "UCI_MATERIAL" 2120 rows imported
460. . importing table "UCI_MATERIAL_COMPONENTE" 15 rows imported
461. . importing table "UCI_MOVIMIENTO_DEFUNCION" 4 rows imported
462. . importing table "UCI_MOVIMIENTO_DESTINO" 14 rows imported
463. . importing table "UCI_OBJETIVO" 302 rows imported
464. . importing table "UCI_OPCION" 24 rows imported
465. . importing table "UCI_ORDEN_INGRESO" 108 rows imported
466. . importing table "UCI_PACIENTE_ANTECEDENTE" 205 rows imported
467. . importing table "UCI_PACIENTE_MONITOREO" 2534 rows imported
468. . importing table "UCI_PACIENTE_MOVIMIENTO" 199 rows imported
469. . importing table "UCI_PACIENTE_PROCEDIMIENTO" 78 rows imported
470. . importing table "UCI_PACIENTE_SCORE" 5553 rows imported
471. . importing table "UCI_PERFIL" 5 rows imported
472. . importing table "UCI_PERFIL_OPCION" 62 rows imported
473. . importing table "UCI_PERSONA" 100 rows imported
474. . importing table "UCI_PERSONA_ASEGURADO" 94 rows imported
475. . importing table "UCI_PERSONA_ASISTENCIAL" 23 rows imported
476. . importing table "UCI_PLAN_CUIDADO" 5 rows imported
477. . importing table "UCI_PROBLEMA" 0 rows imported
478. . importing table "UCI_PROCEDIMIENTO_ACTIVIDAD" 5 rows imported
479. . importing table "UCI_PROCEDIMIENTO_SALUD" 71 rows imported
480. . importing table "UCI_PROCEDIMIENTO_TIPO" 11 rows imported
481. . importing table "UCI_PROCEDIMIENTO_VARIABLE" 9 rows imported
482. . importing table "UCI_PROGRAMACION_ASISTENCIAL" 0 rows imported
483. . importing table "UCI_PROGRAMACION_MEDICAMENTO" 4 rows imported
484. . importing table "UCI_RED_ASISTENCIAL" 0 rows imported
485. . importing table "UCI_SINCRONIZACION" 2 rows imported
486. . importing table "UCI_SINDROME" 2 rows imported
487. . importing table "UCI_SINDROME_DIAGNOSTICO" 5 rows imported
488. . importing table "UCI_SOLICITUD_EXAMEN" 52 rows imported
489. . importing table "UCI_SOLICITUD_EXAMEN_DETALLE" 76 rows imported
490. . importing table "UCI_SOLICITUD_MATERIAL" 122 rows imported
491. . importing table "UCI_SOLICITUD_MATERIAL_DET" 208 rows imported
492. . importing table "UCI_TAXONOMIA_NANDA" 12 rows imported
493. . importing table "UCI_TURNO" 18 rows imported
494. . importing table "UCI_UNIDAD_MEDIDA" 30 rows imported
495. . importing table "UCI_USUARIO" 11 rows imported
496. . importing table "UCI_USUARIO_CENTRO" 0 rows imported
497. . importing table "UCI_USUARIO_ESTRUCTURA" 5 rows imported
498. . importing table "UCI_USUARIO_OPCION" 4 rows imported
499. . importing table "UCI_USUARIO_PERFIL" 3 rows imported
500. . importing table "UCI_VARIABLE" 352 rows imported
501. . importing table "VUELOS" 8 rows imported
502IMP-00015: following statement failed because the object already exists:
503 "CREATE function custom_auth (p_username in VARCHAR2, p_password in VARCHAR2"
504 ")"
505 "return BOOLEAN"
506 "is"
507 " l_password varchar2(4000);"
508 " l_stored_password varchar2(4000);"
509 " l_expires_on date;"
510 " l_count number;"
511 "begin"
512 "-- First, check to see if the user is in the user table"
513 "select count(*) into l_count from demo_users where user_name = p_username;"
514 "if l_count > 0 then"
515 " -- First, we fetch the stored hashed password & expire date"
516 " select password, expires_on into l_stored_password, l_expires_on"
517 " from demo_users where user_name = p_username;"
518 ""
519 " -- Next, we check to see if the user's account is expired"
520 " -- If it is, return FALSE"
521 " if l_expires_on > sysdate or l_expires_on is null then"
522 ""
523 " -- If the account is not expired, we have to apply the custom hash"
524 " -- function to the password"
525 " l_password := custom_hash(p_username, p_password);"
526 ""
527 " -- Finally, we compare them to see if they are the same and return"
528 " -- either TRUE or FALSE"
529 " if l_password = l_stored_password then"
530 " return true;"
531 " else"
532 " return false;"
533 " end if;"
534 " else"
535 " return false;"
536 " end if;"
537 "else"
538 " -- The username provided is not in the DEMO_USERS table"
539 " return false;"
540 "end if;"
541 "end;"
542IMP-00015: following statement failed because the object already exists:
543 "CREATE function custom_hash (p_username in varchar2, p_password in varchar2"
544 ")"
545 "return varchar2"
546 "is"
547 " l_password varchar2(4000);"
548 " l_salt varchar2(4000) := 'VJC315SCQJMJKH6CH16PHSHJ1DICPG';"
549 "begin"
550 ""
551 "-- This function should be wrapped, as the hash algorhythm is exposed here."
552 "-- You can change the value of l_salt or the method of which to call the"
553 "-- DBMS_OBFUSCATOIN toolkit, but you much reset all of your passwords"
554 "-- if you choose to do this."
555 ""
556 "l_password := utl_raw.cast_to_raw(dbms_obfuscation_toolkit.md5"
557 " (input_string => p_password || substr(l_salt,10,13) || p_username ||"
558 " substr(l_salt, 4,10)));"
559 "return l_password;"
560 "end;"
561About to enable constraints...
562Import terminated successfully with warnings.
563
564C:\Users\Christopher Elias>