API tools faq
paste
Advertisement
Guest User

Untitled

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