API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 25th, 2014
144
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 48.08 KB | None | 0 0
raw download clone embed print report
  1. SQL*Loader: Release 11.2.0.2.0 - Production ON �� ��� 26 02:03:46 2014
  2.  
  3. Copyright (c) 1982, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.
  4.  
  5. Control File:   FORMS_DATA_TABLE.ctl
  6. DATA File:      ./FORMS_DATA_TABLE.ldr
  7.   File processing OPTION string: "str '{EOL}'"
  8.   Bad File:     FORMS_DATA_TABLE.bad
  9.   Discard File:  NONE specified
  10.  
  11.  (Allow ALL discards)
  12.  
  13. NUMBER TO LOAD: ALL
  14. NUMBER TO skip: 0
  15. Errors allowed: 57
  16. Bind array:     64 ROWS, maximum OF 256000 bytes
  17. Continuation:   1:1 = 0X23(CHARACTER '#'), IN NEXT physical record
  18. Path used:      Conventional
  19.  
  20. TABLE "FORMS", loaded FROM every logical record.
  21. INSERT OPTION IN effect FOR this TABLE: APPEND
  22. TRAILING NULLCOLS OPTION IN effect
  23.  
  24.    COLUMN Name                  POSITION   Len  Term Encl Datatype
  25. ------------------------------ ---------- ----- ---- ---- ---------------------
  26. "FORM_ID"                           FIRST    64   |  O(") CHARACTER            
  27.                                                      O(")
  28. "FORM_NAME"                          NEXT   512   |  O(") CHARACTER            
  29.                                                      O(")
  30. "FORM_DESCRIPTION"                   NEXT  2048   |  O(") CHARACTER            
  31.                                                      O(")
  32. "ACTIVE_VERSION_ID"                  NEXT    64   |  O(") CHARACTER            
  33.                                                      O(")
  34. "FORM_TYPE"                          NEXT    32   |  O(") CHARACTER            
  35.                                                      O(")
  36.  
  37.  
  38. TABLE "FORMS":
  39.   8 ROWS successfully loaded.
  40.   0 ROWS NOT loaded due TO DATA errors.
  41.   0 ROWS NOT loaded because ALL WHEN clauses were failed.
  42.   0 ROWS NOT loaded because ALL FIELDS were NULL.
  43.  
  44.  
  45. SPACE allocated FOR bind array:                 174720 bytes(64 ROWS)
  46. READ   buffer bytes: 1048576
  47.  
  48. Total logical records skipped:          0
  49. Total logical records READ:             8
  50. Total logical records rejected:         0
  51. Total logical records discarded:        0
  52.  
  53. Run began ON �� ��� 26 02:03:46 2014
  54. Run ended ON �� ��� 26 02:03:46 2014
  55.  
  56. Elapsed TIME was:     00:00:00.05
  57. CPU TIME was:         00:00:00.01
  58.  
  59. SQL*Loader: Release 11.2.0.2.0 - Production ON �� ��� 26 02:03:46 2014
  60.  
  61. Copyright (c) 1982, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.
  62.  
  63. Control File:   FORM_VERSIONS_DATA_TABLE.ctl
  64. DATA File:      ./FORM_VERSIONS_DATA_TABLE.ldr
  65.   File processing OPTION string: "str '{EOL}'"
  66.   Bad File:     FORM_VERSIONS_DATA_TABLE.bad
  67.   Discard File:  NONE specified
  68.  
  69.  (Allow ALL discards)
  70.  
  71. NUMBER TO LOAD: ALL
  72. NUMBER TO skip: 0
  73. Errors allowed: 50
  74. Bind array:     64 ROWS, maximum OF 256000 bytes
  75. Continuation:   1:1 = 0X23(CHARACTER '#'), IN NEXT physical record
  76. Path used:      Conventional
  77.  
  78. TABLE "FORM_VERSIONS", loaded FROM every logical record.
  79. INSERT OPTION IN effect FOR this TABLE: APPEND
  80. TRAILING NULLCOLS OPTION IN effect
  81.  
  82.    COLUMN Name                  POSITION   Len  Term Encl Datatype
  83. ------------------------------ ---------- ----- ---- ---- ---------------------
  84. "VERSION_ID"                        FIRST    64   |  O(") CHARACTER            
  85.                                                      O(")
  86. "FORM_ID"                            NEXT    64   |  O(") CHARACTER            
  87.                                                      O(")
  88. "AUTHOR"                             NEXT    64   |  O(") CHARACTER            
  89.                                                      O(")
  90. "CREATION_DATE"                      NEXT     *   |  O(") DATETIME YYYY-MM-DD HH24:MI:SS.FF
  91.                                                      O(")
  92. "RESOLUTION"                         NEXT     *   |  O(") CHARACTER            
  93.                                                      O(")
  94. "PUBLICATION_DATE"                   NEXT     *   |  O(") DATETIME YYYY-MM-DD HH24:MI:SS.FF
  95.                                                      O(")
  96. L_0                                  NEXT     *   |  O(") CHARACTER            
  97.  (FILLER FIELD)                                      O(")
  98. "PUBLIC_CONFIG"                   DERIVED     *  EOF      CHARACTER            
  99.     Dynamic LOBFILE.  Filename IN FIELD L_0
  100.     NULL IF L_0 = 0X6e756c6c(CHARACTER 'null')
  101. L_1                                  NEXT     *   |  O(") CHARACTER            
  102.  (FILLER FIELD)                                      O(")
  103. "SYSTEM_CONFIG"                   DERIVED     *  EOF      CHARACTER            
  104.     Dynamic LOBFILE.  Filename IN FIELD L_1
  105.     NULL IF L_1 = 0X6e756c6c(CHARACTER 'null')
  106.  
  107.  
  108. TABLE "FORM_VERSIONS":
  109.   9 ROWS successfully loaded.
  110.   0 ROWS NOT loaded due TO DATA errors.
  111.   0 ROWS NOT loaded because ALL WHEN clauses were failed.
  112.   0 ROWS NOT loaded because ALL FIELDS were NULL.
  113.  
  114.  
  115. SPACE allocated FOR bind array:                  95232 bytes(64 ROWS)
  116. READ   buffer bytes: 1048576
  117.  
  118. Total logical records skipped:          0
  119. Total logical records READ:             9
  120. Total logical records rejected:         0
  121. Total logical records discarded:        0
  122.  
  123. Run began ON �� ��� 26 02:03:46 2014
  124. Run ended ON �� ��� 26 02:03:46 2014
  125.  
  126. Elapsed TIME was:     00:00:00.08
  127. CPU TIME was:         00:00:00.02
  128.  
  129. SQL*Loader: Release 11.2.0.2.0 - Production ON �� ��� 26 02:03:44 2014
  130.  
  131. Copyright (c) 1982, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.
  132.  
  133. Control File:   NEWS2INFO_BLOCKS_DATA_TABLE.ctl
  134. DATA File:      ./NEWS2INFO_BLOCKS_DATA_TABLE.ldr
  135.   File processing OPTION string: "str '{EOL}'"
  136.   Bad File:     NEWS2INFO_BLOCKS_DATA_TABLE.bad
  137.   Discard File:  NONE specified
  138.  
  139.  (Allow ALL discards)
  140.  
  141. NUMBER TO LOAD: ALL
  142. NUMBER TO skip: 0
  143. Errors allowed: 4474
  144. Bind array:     64 ROWS, maximum OF 256000 bytes
  145. Continuation:   1:1 = 0X23(CHARACTER '#'), IN NEXT physical record
  146. Path used:      Conventional
  147.  
  148. TABLE "NEWS2INFO_BLOCKS", loaded FROM every logical record.
  149. INSERT OPTION IN effect FOR this TABLE: APPEND
  150. TRAILING NULLCOLS OPTION IN effect
  151.  
  152.    COLUMN Name                  POSITION   Len  Term Encl Datatype
  153. ------------------------------ ---------- ----- ---- ---- ---------------------
  154. "NEWS_ID"                           FIRST    64   |  O(") CHARACTER            
  155.                                                      O(")
  156. "LANG_ID"                            NEXT     *   |  O(") CHARACTER            
  157.                                                      O(")
  158. "BLOCK_ID"                           NEXT    64   |  O(") CHARACTER            
  159.                                                      O(")
  160.  
  161.  
  162. TABLE "NEWS2INFO_BLOCKS":
  163.   39596 ROWS successfully loaded.
  164.   0 ROWS NOT loaded due TO DATA errors.
  165.   0 ROWS NOT loaded because ALL WHEN clauses were failed.
  166.   0 ROWS NOT loaded because ALL FIELDS were NULL.
  167.  
  168.  
  169. SPACE allocated FOR bind array:                  24960 bytes(64 ROWS)
  170. READ   buffer bytes: 1048576
  171.  
  172. Total logical records skipped:          0
  173. Total logical records READ:         39596
  174. Total logical records rejected:         0
  175. Total logical records discarded:        0
  176.  
  177. Run began ON �� ��� 26 02:03:44 2014
  178. Run ended ON �� ��� 26 02:03:45 2014
  179.  
  180. Elapsed TIME was:     00:00:01.34
  181. CPU TIME was:         00:00:00.25
  182.  
  183. SQL*Loader: Release 11.2.0.2.0 - Production ON �� ��� 26 02:03:38 2014
  184.  
  185. Copyright (c) 1982, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.
  186.  
  187. Control File:   NEWS2REGIONS_DATA_TABLE.ctl
  188. DATA File:      ./NEWS2REGIONS_DATA_TABLE.ldr
  189.   File processing OPTION string: "str '{EOL}'"
  190.   Bad File:     NEWS2REGIONS_DATA_TABLE.bad
  191.   Discard File:  NONE specified
  192.  
  193.  (Allow ALL discards)
  194.  
  195. NUMBER TO LOAD: ALL
  196. NUMBER TO skip: 0
  197. Errors allowed: 5153
  198. Bind array:     64 ROWS, maximum OF 256000 bytes
  199. Continuation:   1:1 = 0X23(CHARACTER '#'), IN NEXT physical record
  200. Path used:      Conventional
  201.  
  202. TABLE "NEWS2REGIONS", loaded FROM every logical record.
  203. INSERT OPTION IN effect FOR this TABLE: APPEND
  204. TRAILING NULLCOLS OPTION IN effect
  205.  
  206.    COLUMN Name                  POSITION   Len  Term Encl Datatype
  207. ------------------------------ ---------- ----- ---- ---- ---------------------
  208. "NEWS_ID"                           FIRST    64   |  O(") CHARACTER            
  209.                                                      O(")
  210. "LANG_ID"                            NEXT     *   |  O(") CHARACTER            
  211.                                                      O(")
  212. "REGION_ID"                          NEXT     *   |  O(") CHARACTER            
  213.                                                      O(")
  214. "REGION_ID2"                         NEXT     3   |  O(") CHARACTER            
  215.                                                      O(")
  216.  
  217.  
  218. TABLE "NEWS2REGIONS":
  219.   51284 ROWS successfully loaded.
  220.   0 ROWS NOT loaded due TO DATA errors.
  221.   0 ROWS NOT loaded because ALL WHEN clauses were failed.
  222.   0 ROWS NOT loaded because ALL FIELDS were NULL.
  223.  
  224.  
  225. SPACE allocated FOR bind array:                  37632 bytes(64 ROWS)
  226. READ   buffer bytes: 1048576
  227.  
  228. Total logical records skipped:          0
  229. Total logical records READ:         51284
  230. Total logical records rejected:         0
  231. Total logical records discarded:        0
  232.  
  233. Run began ON �� ��� 26 02:03:38 2014
  234. Run ended ON �� ��� 26 02:03:41 2014
  235.  
  236. Elapsed TIME was:     00:00:02.40
  237. CPU TIME was:         00:00:00.39
  238.  
  239. SQL*Loader: Release 11.2.0.2.0 - Production ON �� ��� 26 02:03:46 2014
  240.  
  241. Copyright (c) 1982, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.
  242.  
  243. Control File:   NEWS_INFO_BLOCKS_DATA_TABLE.ctl
  244. DATA File:      ./NEWS_INFO_BLOCKS_DATA_TABLE.ldr
  245.   File processing OPTION string: "str '{EOL}'"
  246.   Bad File:     NEWS_INFO_BLOCKS_DATA_TABLE.bad
  247.   Discard File:  NONE specified
  248.  
  249.  (Allow ALL discards)
  250.  
  251. NUMBER TO LOAD: ALL
  252. NUMBER TO skip: 0
  253. Errors allowed: 570
  254. Bind array:     64 ROWS, maximum OF 256000 bytes
  255. Continuation:   1:1 = 0X23(CHARACTER '#'), IN NEXT physical record
  256. Path used:      Conventional
  257.  
  258. TABLE "NEWS_INFO_BLOCKS", loaded FROM every logical record.
  259. INSERT OPTION IN effect FOR this TABLE: APPEND
  260. TRAILING NULLCOLS OPTION IN effect
  261.  
  262.    COLUMN Name                  POSITION   Len  Term Encl Datatype
  263. ------------------------------ ---------- ----- ---- ---- ---------------------
  264. "BLOCK_ID"                          FIRST    64   |  O(") CHARACTER            
  265.                                                      O(")
  266. "BLOCK_NAME"                         NEXT   256   |  O(") CHARACTER            
  267.                                                      O(")
  268. "ARCHIVE"                            NEXT   256   |  O(") CHARACTER            
  269.                                                      O(")
  270. "CREATED_DATE"                       NEXT     *   |  O(") DATE YYYY-MM-DD HH24:MI:SS
  271.                                                      O(")
  272.  
  273. Record 1: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  274. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  275.  
  276. Record 2: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  277. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  278.  
  279. Record 3: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  280. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  281.  
  282. Record 4: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  283. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  284.  
  285. Record 5: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  286. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  287.  
  288. Record 6: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  289. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  290.  
  291. Record 7: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  292. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  293.  
  294. Record 8: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  295. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  296.  
  297. Record 9: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  298. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  299.  
  300. Record 10: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  301. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  302.  
  303. Record 11: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  304. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  305.  
  306. Record 12: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  307. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  308.  
  309. Record 13: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  310. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  311.  
  312. Record 14: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  313. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  314.  
  315. Record 15: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  316. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  317.  
  318. Record 16: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  319. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  320.  
  321. Record 17: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  322. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  323.  
  324. Record 18: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  325. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  326.  
  327. Record 19: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  328. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  329.  
  330. Record 20: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  331. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  332.  
  333. Record 21: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  334. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  335.  
  336. Record 22: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  337. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  338.  
  339. Record 23: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  340. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  341.  
  342. Record 24: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  343. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  344.  
  345. Record 25: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  346. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  347.  
  348. Record 26: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  349. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  350.  
  351. Record 27: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  352. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  353.  
  354. Record 28: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  355. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  356.  
  357. Record 29: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  358. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  359.  
  360. Record 30: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  361. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  362.  
  363. Record 31: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  364. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  365.  
  366. Record 32: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  367. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  368.  
  369. Record 33: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  370. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  371.  
  372. Record 34: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  373. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  374.  
  375. Record 35: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  376. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  377.  
  378. Record 36: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  379. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  380.  
  381. Record 37: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  382. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  383.  
  384. Record 38: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  385. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  386.  
  387. Record 39: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  388. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  389.  
  390. Record 40: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  391. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  392.  
  393. Record 41: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  394. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  395.  
  396. Record 42: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  397. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  398.  
  399. Record 43: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  400. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  401.  
  402. Record 44: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  403. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  404.  
  405. Record 45: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  406. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  407.  
  408. Record 46: Rejected - Error ON TABLE "NEWS_INFO_BLOCKS".
  409. ORA-00001: �������� ����������� ������������ (SCRIPTTEST.NEWS_INFO_BLOCKS_PK)
  410.  
  411.  
  412. TABLE "NEWS_INFO_BLOCKS":
  413.   0 ROWS successfully loaded.
  414.   46 ROWS NOT loaded due TO DATA errors.
  415.   0 ROWS NOT loaded because ALL WHEN clauses were failed.
  416.   0 ROWS NOT loaded because ALL FIELDS were NULL.
  417.  
  418.  
  419. SPACE allocated FOR bind array:                  53760 bytes(64 ROWS)
  420. READ   buffer bytes: 1048576
  421.  
  422. Total logical records skipped:          0
  423. Total logical records READ:            46
  424. Total logical records rejected:        46
  425. Total logical records discarded:        0
  426.  
  427. Run began ON �� ��� 26 02:03:46 2014
  428. Run ended ON �� ��� 26 02:03:46 2014
  429.  
  430. Elapsed TIME was:     00:00:00.10
  431. CPU TIME was:         00:00:00.02
  432.  
  433. SQL*Loader: Release 11.2.0.2.0 - Production ON �� ��� 26 02:03:46 2014
  434.  
  435. Copyright (c) 1982, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.
  436.  
  437. Control File:   NEWS_NEW_DATA_TABLE.ctl
  438. DATA File:      ./NEWS_NEW_DATA_TABLE.ldr
  439.   File processing OPTION string: "str '{EOL}'"
  440.   Bad File:     NEWS_NEW_DATA_TABLE.bad
  441.   Discard File:  NONE specified
  442.  
  443.  (Allow ALL discards)
  444.  
  445. NUMBER TO LOAD: ALL
  446. NUMBER TO skip: 0
  447. Errors allowed: 5655
  448. Bind array:     64 ROWS, maximum OF 256000 bytes
  449. Continuation:   1:1 = 0X23(CHARACTER '#'), IN NEXT physical record
  450. Path used:      Conventional
  451.  
  452. TABLE "NEWS", loaded FROM every logical record.
  453. INSERT OPTION IN effect FOR this TABLE: APPEND
  454. TRAILING NULLCOLS OPTION IN effect
  455.  
  456.    COLUMN Name                  POSITION   Len  Term Encl Datatype
  457. ------------------------------ ---------- ----- ---- ---- ---------------------
  458. "NEWS_ID"                           FIRST    64   |  O(") CHARACTER            
  459.                                                      O(")
  460. "LANG_ID"                            NEXT     *   |  O(") CHARACTER            
  461.                                                      O(")
  462. "TITLE"                              NEXT  4000   |  O(") CHARACTER            
  463.                                                      O(")
  464. L_0                                  NEXT     *   |  O(") CHARACTER            
  465.  (FILLER FIELD)                                      O(")
  466. "ANNOUNCE"                        DERIVED     *  EOF      CHARACTER            
  467.     Dynamic LOBFILE.  Filename IN FIELD L_0
  468.     NULL IF L_0 = 0X6e756c6c(CHARACTER 'null')
  469. L_1                                  NEXT     *   |  O(") CHARACTER            
  470.  (FILLER FIELD)                                      O(")
  471. "TEXT"                            DERIVED     *  EOF      CHARACTER            
  472.     Dynamic LOBFILE.  Filename IN FIELD L_1
  473.     NULL IF L_1 = 0X6e756c6c(CHARACTER 'null')
  474. "NEWS_DATE"                          NEXT     *   |  O(") DATETIME YYYY-MM-DD HH24:MI:SS.FF
  475.                                                      O(")
  476. "IMG_ID"                             NEXT    64   |  O(") CHARACTER            
  477.                                                      O(")
  478. "SMALL_IMG_ID"                       NEXT    64   |  O(") CHARACTER            
  479.                                                      O(")
  480. "TYPE"                               NEXT    20   |  O(") CHARACTER            
  481.                                                      O(")
  482. "QUOTE"                              NEXT  4000   |  O(") CHARACTER            
  483.                                                      O(")
  484. "COUNTRY_CODE"                       NEXT    64   |  O(") CHARACTER            
  485.                                                      O(")
  486. "IS_PUBLISHED"                       NEXT     *   |  O(") CHARACTER            
  487.                                                      O(")
  488. "PUBLISHING_DATE"                    NEXT     *   |  O(") DATE YYYY-MM-DD HH24:MI:SS
  489.                                                      O(")
  490.  
  491. VALUE used FOR ROWS parameter changed FROM 64 TO 26
  492. Record 7: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  493. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 1316, ������������: 512)
  494.  
  495. Record 15: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  496. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 1892, ������������: 512)
  497.  
  498. Record 16: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  499. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 561, ������������: 512)
  500.  
  501. Record 17: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  502. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 1785, ������������: 512)
  503.  
  504. Record 27: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  505. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 1414, ������������: 512)
  506.  
  507. Record 28: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  508. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 1191, ������������: 512)
  509.  
  510. Record 29: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  511. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 1293, ������������: 512)
  512.  
  513. Record 40: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  514. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 654, ������������: 512)
  515.  
  516. Record 124: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  517. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 1656, ������������: 512)
  518.  
  519. Record 131: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  520. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 611, ������������: 512)
  521.  
  522. Record 164: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  523. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 633, ������������: 512)
  524.  
  525. Record 676: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  526. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 1479, ������������: 512)
  527.  
  528. Record 687: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  529. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 924, ������������: 512)
  530.  
  531. Record 697: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  532. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 1320, ������������: 512)
  533.  
  534. Record 708: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  535. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 1136, ������������: 512)
  536.  
  537. Record 1627: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  538. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 642, ������������: 512)
  539.  
  540. Record 1630: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  541. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 642, ������������: 512)
  542.  
  543. Record 1631: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  544. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 642, ������������: 512)
  545.  
  546. Record 1903: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  547. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 642, ������������: 512)
  548.  
  549. Record 17537: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  550. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 541, ������������: 512)
  551.  
  552. Record 20547: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  553. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 514, ������������: 512)
  554.  
  555. Record 20571: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  556. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 523, ������������: 512)
  557.  
  558. Record 21773: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  559. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 655, ������������: 512)
  560.  
  561. Record 22083: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  562. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 625, ������������: 512)
  563.  
  564. Record 22334: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  565. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 689, ������������: 512)
  566.  
  567. Record 22548: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  568. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 625, ������������: 512)
  569.  
  570. Record 25006: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  571. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 526, ������������: 512)
  572.  
  573. Record 38470: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  574. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 548, ������������: 512)
  575.  
  576. Record 42550: Rejected - Error ON TABLE "NEWS", COLUMN "TITLE".
  577. ORA-12899: �������� ��� ������� "SCRIPTTEST"."NEWS"."TITLE" ������� ������ (�����������: 528, ������������: 512)
  578.  
  579.  
  580. TABLE "NEWS":
  581.   52055 ROWS successfully loaded.
  582.   29 ROWS NOT loaded due TO DATA errors.
  583.   0 ROWS NOT loaded because ALL WHEN clauses were failed.
  584.   0 ROWS NOT loaded because ALL FIELDS were NULL.
  585.  
  586.  
  587. SPACE allocated FOR bind array:                 255788 bytes(26 ROWS)
  588. READ   buffer bytes: 1048576
  589.  
  590. Total logical records skipped:          0
  591. Total logical records READ:         52084
  592. Total logical records rejected:        29
  593. Total logical records discarded:        0
  594.  
  595. Run began ON �� ��� 26 02:03:46 2014
  596. Run ended ON �� ��� 26 02:05:17 2014
  597.  
  598. Elapsed TIME was:     00:01:30.48
  599. CPU TIME was:         00:00:16.89
  600.  
  601. SQL*Loader: Release 11.2.0.2.0 - Production ON �� ��� 26 02:03:46 2014
  602.  
  603. Copyright (c) 1982, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.
  604.  
  605. Control File:   PRODUCT_DATA_TABLE.ctl
  606. DATA File:      ./PRODUCT_DATA_TABLE.ldr
  607.   File processing OPTION string: "str '{EOL}'"
  608.   Bad File:     PRODUCT_DATA_TABLE.bad
  609.   Discard File:  NONE specified
  610.  
  611.  (Allow ALL discards)
  612.  
  613. NUMBER TO LOAD: ALL
  614. NUMBER TO skip: 0
  615. Errors allowed: 50
  616. Bind array:     64 ROWS, maximum OF 256000 bytes
  617. Continuation:   1:1 = 0X23(CHARACTER '#'), IN NEXT physical record
  618. Path used:      Conventional
  619.  
  620. TABLE "PRODUCT", loaded FROM every logical record.
  621. INSERT OPTION IN effect FOR this TABLE: APPEND
  622. TRAILING NULLCOLS OPTION IN effect
  623.  
  624.    COLUMN Name                  POSITION   Len  Term Encl Datatype
  625. ------------------------------ ---------- ----- ---- ---- ---------------------
  626. "ID"                                FIRST    64   |  O(") CHARACTER            
  627.                                                      O(")
  628. "NAME"                               NEXT   512   |  O(") CHARACTER            
  629.                                                      O(")
  630. "REGION"                             NEXT    20   |  O(") CHARACTER            
  631.                                                      O(")
  632. "SHORT_NAME"                         NEXT   256   |  O(") CHARACTER            
  633.                                                      O(")
  634. "DESCRIPTION"                        NEXT  4000   |  O(") CHARACTER            
  635.                                                      O(")
  636. "ORDER_NUM"                          NEXT     *   |  O(") CHARACTER            
  637.                                                      O(")
  638. "VISIBILITY"                         NEXT    40   |  O(") CHARACTER            
  639.                                                      O(")
  640. "TER_BANK"                           NEXT    64   |  O(") CHARACTER            
  641.                                                      O(")
  642. "PRODUCT_TYPE_ID"                    NEXT    64   |  O(") CHARACTER            
  643.                                                      O(")
  644. "PRODUCT_CODE"                       NEXT    64   |  O(") CHARACTER            
  645.                                                      O(")
  646. "ACTIVE_VERSION_ID"                  NEXT    64   |  O(") CHARACTER            
  647.                                                      O(")
  648. "PARENT_PRODUCT_ID"                  NEXT    64   |  O(") CHARACTER            
  649.                                                      O(")
  650.  
  651. VALUE used FOR ROWS parameter changed FROM 64 TO 46
  652.  
  653. TABLE "PRODUCT":
  654.   280 ROWS successfully loaded.
  655.   0 ROWS NOT loaded due TO DATA errors.
  656.   0 ROWS NOT loaded because ALL WHEN clauses were failed.
  657.   0 ROWS NOT loaded because ALL FIELDS were NULL.
  658.  
  659.  
  660. SPACE allocated FOR bind array:                 252632 bytes(46 ROWS)
  661. READ   buffer bytes: 1048576
  662.  
  663. Total logical records skipped:          0
  664. Total logical records READ:           280
  665. Total logical records rejected:         0
  666. Total logical records discarded:        0
  667.  
  668. Run began ON �� ��� 26 02:03:46 2014
  669. Run ended ON �� ��� 26 02:03:46 2014
  670.  
  671. Elapsed TIME was:     00:00:00.07
  672. CPU TIME was:         00:00:00.01
  673.  
  674. SQL*Loader: Release 11.2.0.2.0 - Production ON �� ��� 26 02:03:41 2014
  675.  
  676. Copyright (c) 1982, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.
  677.  
  678. Control File:   PRODUCT_FIELD_DATA_TABLE.ctl
  679. DATA File:      ./PRODUCT_FIELD_DATA_TABLE.ldr
  680.   File processing OPTION string: "str '{EOL}'"
  681.   Bad File:     PRODUCT_FIELD_DATA_TABLE.bad
  682.   Discard File:  NONE specified
  683.  
  684.  (Allow ALL discards)
  685.  
  686. NUMBER TO LOAD: ALL
  687. NUMBER TO skip: 0
  688. Errors allowed: 2621
  689. Bind array:     64 ROWS, maximum OF 256000 bytes
  690. Continuation:   1:1 = 0X23(CHARACTER '#'), IN NEXT physical record
  691. Path used:      Conventional
  692.  
  693. TABLE "PRODUCT_FIELD", loaded FROM every logical record.
  694. INSERT OPTION IN effect FOR this TABLE: APPEND
  695. TRAILING NULLCOLS OPTION IN effect
  696.  
  697.    COLUMN Name                  POSITION   Len  Term Encl Datatype
  698. ------------------------------ ---------- ----- ---- ---- ---------------------
  699. "ID"                                FIRST    64   |  O(") CHARACTER            
  700.                                                      O(")
  701. "PRODUCT_VERSION_ID"                 NEXT    64   |  O(") CHARACTER            
  702.                                                      O(")
  703. "STR_VALUE"                          NEXT  4000   |  O(") CHARACTER            
  704.                                                      O(")
  705. "DATE_VALUE"                         NEXT    20   |  O(") CHARACTER            
  706.                                                      O(")
  707. "COMPLEX_VALUE"                      NEXT  4000   |  O(") CHARACTER            
  708.                                                      O(")
  709. "FILE_ID"                            NEXT   256   |  O(") CHARACTER            
  710.                                                      O(")
  711. "ATTRIBUTE_ID"                       NEXT    64   |  O(") CHARACTER            
  712.                                                      O(")
  713. "IS_MULTIVALUE"                      NEXT     *   |  O(") CHARACTER            
  714.                                                      O(")
  715. "NUMBER_VALUE"                       NEXT     *   |  O(") CHARACTER            
  716.                                                      O(")
  717. "EXT_TYPE_INFO"                      NEXT  4000   |  O(") CHARACTER            
  718.                                                      O(")
  719. "MULTIVALUE_ORDER"                   NEXT     *   |  O(") CHARACTER            
  720.                                                      O(")
  721.  
  722. VALUE used FOR ROWS parameter changed FROM 64 TO 19
  723.  
  724. TABLE "PRODUCT_FIELD":
  725.   26164 ROWS successfully loaded.
  726.   0 ROWS NOT loaded due TO DATA errors.
  727.   0 ROWS NOT loaded because ALL WHEN clauses were failed.
  728.   0 ROWS NOT loaded because ALL FIELDS were NULL.
  729.  
  730.  
  731. SPACE allocated FOR bind array:                 251902 bytes(19 ROWS)
  732. READ   buffer bytes: 1048576
  733.  
  734. Total logical records skipped:          0
  735. Total logical records READ:         26164
  736. Total logical records rejected:         0
  737. Total logical records discarded:        0
  738.  
  739. Run began ON �� ��� 26 02:03:41 2014
  740. Run ended ON �� ��� 26 02:03:44 2014
  741.  
  742. Elapsed TIME was:     00:00:03.22
  743. CPU TIME was:         00:00:00.54
  744.  
  745. SQL*Loader: Release 11.2.0.2.0 - Production ON �� ��� 26 02:03:46 2014
  746.  
  747. Copyright (c) 1982, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.
  748.  
  749. Control File:   PRODUCT_TYPE_DATA_TABLE.ctl
  750. DATA File:      ./PRODUCT_TYPE_DATA_TABLE.ldr
  751.   File processing OPTION string: "str '{EOL}'"
  752.   Bad File:     PRODUCT_TYPE_DATA_TABLE.bad
  753.   Discard File:  NONE specified
  754.  
  755.  (Allow ALL discards)
  756.  
  757. NUMBER TO LOAD: ALL
  758. NUMBER TO skip: 0
  759. Errors allowed: 262
  760. Bind array:     64 ROWS, maximum OF 256000 bytes
  761. Continuation:   1:1 = 0X23(CHARACTER '#'), IN NEXT physical record
  762. Path used:      Conventional
  763.  
  764. TABLE "PRODUCT_TYPE", loaded FROM every logical record.
  765. INSERT OPTION IN effect FOR this TABLE: APPEND
  766. TRAILING NULLCOLS OPTION IN effect
  767.  
  768.    COLUMN Name                  POSITION   Len  Term Encl Datatype
  769. ------------------------------ ---------- ----- ---- ---- ---------------------
  770. "ID"                                FIRST    64   |  O(") CHARACTER            
  771.                                                      O(")
  772. "PRODUCT_TYPE_NAME"                  NEXT   100   |  O(") CHARACTER            
  773.                                                      O(")
  774. L_0                                  NEXT     *   |  O(") CHARACTER            
  775.  (FILLER FIELD)                                      O(")
  776. "DEFINITION"                      DERIVED     *  EOF      CHARACTER            
  777.     Dynamic LOBFILE.  Filename IN FIELD L_0
  778.     NULL IF L_0 = 0X6e756c6c(CHARACTER 'null')
  779. "PRODUCT_TYPE_CODE"                  NEXT   256   |  O(") CHARACTER            
  780.                                                      O(")
  781.  
  782.  
  783. TABLE "PRODUCT_TYPE":
  784.   3 ROWS successfully loaded.
  785.   0 ROWS NOT loaded due TO DATA errors.
  786.   0 ROWS NOT loaded because ALL WHEN clauses were failed.
  787.   0 ROWS NOT loaded because ALL FIELDS were NULL.
  788.  
  789.  
  790. SPACE allocated FOR bind array:                  43776 bytes(64 ROWS)
  791. READ   buffer bytes: 1048576
  792.  
  793. Total logical records skipped:          0
  794. Total logical records READ:             3
  795. Total logical records rejected:         0
  796. Total logical records discarded:        0
  797.  
  798. Run began ON �� ��� 26 02:03:46 2014
  799. Run ended ON �� ��� 26 02:03:46 2014
  800.  
  801. Elapsed TIME was:     00:00:00.06
  802. CPU TIME was:         00:00:00.01
  803.  
  804. SQL*Loader: Release 11.2.0.2.0 - Production ON �� ��� 26 02:05:17 2014
  805.  
  806. Copyright (c) 1982, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.
  807.  
  808. Control File:   PRODUCT_VERSION_DATA_TABLE.ctl
  809. DATA File:      ./PRODUCT_VERSION_DATA_TABLE.ldr
  810.   File processing OPTION string: "str '{EOL}'"
  811.   Bad File:     PRODUCT_VERSION_DATA_TABLE.bad
  812.   Discard File:  NONE specified
  813.  
  814.  (Allow ALL discards)
  815.  
  816. NUMBER TO LOAD: ALL
  817. NUMBER TO skip: 0
  818. Errors allowed: 183
  819. Bind array:     64 ROWS, maximum OF 256000 bytes
  820. Continuation:   1:1 = 0X23(CHARACTER '#'), IN NEXT physical record
  821. Path used:      Conventional
  822.  
  823. TABLE "PRODUCT_VERSION", loaded FROM every logical record.
  824. INSERT OPTION IN effect FOR this TABLE: APPEND
  825. TRAILING NULLCOLS OPTION IN effect
  826.  
  827.    COLUMN Name                  POSITION   Len  Term Encl Datatype
  828. ------------------------------ ---------- ----- ---- ---- ---------------------
  829. "ID"                                FIRST    64   |  O(") CHARACTER            
  830.                                                      O(")
  831. "PRODUCT_ID"                         NEXT    64   |  O(") CHARACTER            
  832.                                                      O(")
  833. "VERSION"                            NEXT     *   |  O(") CHARACTER            
  834.                                                      O(")
  835. "DESCRIPTION"                        NEXT  2000   |  O(") CHARACTER            
  836.                                                      O(")
  837. "ACTIVE_FROM"                        NEXT     *   |  O(") DATE YYYY-MM-DD HH24:MI:SS
  838.                                                      O(")
  839. "ACTIVE_TO"                          NEXT     *   |  O(") DATE YYYY-MM-DD HH24:MI:SS
  840.                                                      O(")
  841. "IS_LOCAL_ACTIVE_FROM"               NEXT     *   |  O(") CHARACTER            
  842.                                                      O(")
  843. "IS_LOCAL_ACTIVE_TO"                 NEXT     *   |  O(") CHARACTER            
  844.                                                      O(")
  845. "IS_ENABLE"                          NEXT     *   |  O(") CHARACTER            
  846.                                                      O(")
  847.  
  848.  
  849. TABLE "PRODUCT_VERSION":
  850.   1571 ROWS successfully loaded.
  851.   0 ROWS NOT loaded due TO DATA errors.
  852.   0 ROWS NOT loaded because ALL WHEN clauses were failed.
  853.   0 ROWS NOT loaded because ALL FIELDS were NULL.
  854.  
  855.  
  856. SPACE allocated FOR bind array:                 235648 bytes(64 ROWS)
  857. READ   buffer bytes: 1048576
  858.  
  859. Total logical records skipped:          0
  860. Total logical records READ:          1571
  861. Total logical records rejected:         0
  862. Total logical records discarded:        0
  863.  
  864. Run began ON �� ��� 26 02:05:17 2014
  865. Run ended ON �� ��� 26 02:05:17 2014
  866.  
  867. Elapsed TIME was:     00:00:00.16
  868. CPU TIME was:         00:00:00.03
  869.  
  870. SQL*Loader: Release 11.2.0.2.0 - Production ON �� ��� 26 02:03:46 2014
  871.  
  872. Copyright (c) 1982, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.
  873.  
  874. Control File:   PRODUCT_VERSION_REGIONS_DATA_TABLE.ctl
  875. DATA File:      ./PRODUCT_VERSION_REGIONS_DATA_TABLE.ldr
  876.   File processing OPTION string: "str '{EOL}'"
  877.   Bad File:     PRODUCT_VERSION_REGIONS_DATA_TABLE.bad
  878.   Discard File:  NONE specified
  879.  
  880.  (Allow ALL discards)
  881.  
  882. NUMBER TO LOAD: ALL
  883. NUMBER TO skip: 0
  884. Errors allowed: 50
  885. Bind array:     64 ROWS, maximum OF 256000 bytes
  886. Continuation:   1:1 = 0X23(CHARACTER '#'), IN NEXT physical record
  887. Path used:      Conventional
  888.  
  889. TABLE "PRODUCT_VERSION_REGIONS", loaded FROM every logical record.
  890. INSERT OPTION IN effect FOR this TABLE: APPEND
  891. TRAILING NULLCOLS OPTION IN effect
  892.  
  893.    COLUMN Name                  POSITION   Len  Term Encl Datatype
  894. ------------------------------ ---------- ----- ---- ---- ---------------------
  895. "VERSION_ID"                        FIRST    64   |  O(") CHARACTER            
  896.                                                      O(")
  897. "REGION_ID"                          NEXT    20   |  O(") CHARACTER            
  898.                                                      O(")
  899.  
  900.  
  901. TABLE "PRODUCT_VERSION_REGIONS":
  902.   55 ROWS successfully loaded.
  903.   0 ROWS NOT loaded due TO DATA errors.
  904.   0 ROWS NOT loaded because ALL WHEN clauses were failed.
  905.   0 ROWS NOT loaded because ALL FIELDS were NULL.
  906.  
  907.  
  908. SPACE allocated FOR bind array:                   5632 bytes(64 ROWS)
  909. READ   buffer bytes: 1048576
  910.  
  911. Total logical records skipped:          0
  912. Total logical records READ:            55
  913. Total logical records rejected:         0
  914. Total logical records discarded:        0
  915.  
  916. Run began ON �� ��� 26 02:03:46 2014
  917. Run ended ON �� ��� 26 02:03:46 2014
  918.  
  919. Elapsed TIME was:     00:00:00.05
  920. CPU TIME was:         00:00:00.02
  921.  
  922. SQL*Loader: Release 11.2.0.2.0 - Production ON �� ��� 26 02:05:17 2014
  923.  
  924. Copyright (c) 1982, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.
  925.  
  926. Control File:   TEMP_FILE_STORE_DATA_TABLE.ctl
  927. DATA File:      ./TEMP_FILE_STORE_DATA_TABLE.ldr
  928.   File processing OPTION string: "str '{EOL}'"
  929.   Bad File:     TEMP_FILE_STORE_DATA_TABLE.bad
  930.   Discard File:  NONE specified
  931.  
  932.  (Allow ALL discards)
  933.  
  934. NUMBER TO LOAD: ALL
  935. NUMBER TO skip: 0
  936. Errors allowed: 253
  937. Bind array:     64 ROWS, maximum OF 256000 bytes
  938. Continuation:   1:1 = 0X23(CHARACTER '#'), IN NEXT physical record
  939. Path used:      Conventional
  940.  
  941. TABLE "TEMP_FILE_STORE", loaded FROM every logical record.
  942. INSERT OPTION IN effect FOR this TABLE: APPEND
  943. TRAILING NULLCOLS OPTION IN effect
  944.  
  945.    COLUMN Name                  POSITION   Len  Term Encl Datatype
  946. ------------------------------ ---------- ----- ---- ---- ---------------------
  947. "ID"                                FIRST   100   |  O(") CHARACTER            
  948.                                                      O(")
  949. L_0                                  NEXT     *   |  O(") CHARACTER            
  950.  (FILLER FIELD)                                      O(")
  951. "BINARY_VALUE"                    DERIVED     *  EOF      CHARACTER            
  952.     Dynamic LOBFILE.  Filename IN FIELD L_0
  953.     NULL IF L_0 = 0X6e756c6c(CHARACTER 'null')
  954. "FILE_NAME"                          NEXT   100   |  O(") CHARACTER            
  955.                                                      O(")
  956. "CREATED"                            NEXT     *   |  O(") DATE YYYY-MM-DD HH24:MI:SS
  957.                                                      O(")
  958. "IS_TEMP"                            NEXT     *   |  O(") CHARACTER            
  959.                                                      O(")
  960. "FS_PATH"                            NEXT  2048   |  O(") CHARACTER            
  961.                                                      O(")
  962.  
  963.  
  964. TABLE "TEMP_FILE_STORE":
  965.   1802 ROWS successfully loaded.
  966.   0 ROWS NOT loaded due TO DATA errors.
  967.   0 ROWS NOT loaded because ALL WHEN clauses were failed.
  968.   0 ROWS NOT loaded because ALL FIELDS were NULL.
  969.  
  970.  
  971. SPACE allocated FOR bind array:                 193792 bytes(64 ROWS)
  972. READ   buffer bytes: 1048576
  973.  
  974. Total logical records skipped:          0
  975. Total logical records READ:          1802
  976. Total logical records rejected:         0
  977. Total logical records discarded:        0
  978.  
  979. Run began ON �� ��� 26 02:05:17 2014
  980. Run ended ON �� ��� 26 02:05:17 2014
  981.  
  982. Elapsed TIME was:     00:00:00.21
  983. CPU TIME was:         00:00:00.04
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!