Advertisement
Guest User

Inserty

a guest
Jun 20th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.37 KB | None | 0 0
  1.  
  2. Error starting at line : 4 in command -
  3. insert into Country values(
  4. 1, Hungary)
  5. Error at Command Line : 5 Column : 8
  6. Error report -
  7. SQL Error: ORA-00984: column not allowed here
  8. 00984. 00000 - "column not allowed here"
  9. *Cause:
  10. *Action:
  11.  
  12. Error starting at line : 6 in command -
  13. insert into Country values(
  14. 2, France)
  15. Error at Command Line : 7 Column : 8
  16. Error report -
  17. SQL Error: ORA-00984: column not allowed here
  18. 00984. 00000 - "column not allowed here"
  19. *Cause:
  20. *Action:
  21.  
  22. Error starting at line : 8 in command -
  23. insert into Country values(
  24. 3, Poland)
  25. Error at Command Line : 9 Column : 8
  26. Error report -
  27. SQL Error: ORA-00984: column not allowed here
  28. 00984. 00000 - "column not allowed here"
  29. *Cause:
  30. *Action:
  31.  
  32. Error starting at line : 10 in command -
  33. insert into Country values(
  34. 4, England)
  35. Error at Command Line : 11 Column : 8
  36. Error report -
  37. SQL Error: ORA-00984: column not allowed here
  38. 00984. 00000 - "column not allowed here"
  39. *Cause:
  40. *Action:
  41.  
  42. Error starting at line : 12 in command -
  43. insert into Country values(
  44. 5, German)
  45. Error at Command Line : 13 Column : 8
  46. Error report -
  47. SQL Error: ORA-00984: column not allowed here
  48. 00984. 00000 - "column not allowed here"
  49. *Cause:
  50. *Action:
  51.  
  52. Error starting at line : 16 in command -
  53. insert into Person values(
  54. 1, 'Bob', 'Ross', 1, '2000-01-01', '758473829', null)
  55. Error report -
  56. ORA-01400: cannot insert NULL into ("S16766"."PERSON"."ADDITIONAL_CONTACT_INFO")
  57.  
  58.  
  59. Error starting at line : 18 in command -
  60. insert into Person values(
  61. 2, 'Jeli', 'Papon', 2, '1973-10-16', '548391035', 'wife 504782287')
  62. Error report -
  63. ORA-02291: integrity constraint (S16766.PERSON_COUNTRY) violated - parent key not found
  64.  
  65.  
  66. Error starting at line : 20 in command -
  67. insert into Person values(
  68. 3, 'Count', 'Olaf', 5, '1953-12-24', '784020135', 'orphans 997998999')
  69. Error report -
  70. ORA-02291: integrity constraint (S16766.PERSON_COUNTRY) violated - parent key not found
  71.  
  72.  
  73. Error starting at line : 22 in command -
  74. insert into Person values(
  75. 4, 'Baudelaire', 'Orphans', 4, '2003-04-13', '997998999', null)
  76. Error report -
  77. ORA-01400: cannot insert NULL into ("S16766"."PERSON"."ADDITIONAL_CONTACT_INFO")
  78.  
  79.  
  80. Error starting at line : 24 in command -
  81. insert into Person values(
  82. 5, 'Scooby', 'Doo', 1, '1983-07-14', '560000813', 'Shaggy 098765432')
  83. Error report -
  84. ORA-02291: integrity constraint (S16766.PERSON_COUNTRY) violated - parent key not found
  85.  
  86.  
  87. Error starting at line : 26 in command -
  88. insert into Person values(
  89. 6, 'Shaggy', 'Doo', 1, '1983-07-15', '098765432', 'Scooby 560000813')
  90. Error report -
  91. ORA-02291: integrity constraint (S16766.PERSON_COUNTRY) violated - parent key not found
  92.  
  93.  
  94. Error starting at line : 28 in command -
  95. insert into Person values(
  96. 7, 'Sherlock', 'Holmes', 4, '1943-12-31', '667892047', 'dr Watson 112999991')
  97. Error report -
  98. ORA-02291: integrity constraint (S16766.PERSON_COUNTRY) violated - parent key not found
  99.  
  100.  
  101. Error starting at line : 30 in command -
  102. insert into Person values(
  103. 8, 'Magda', 'Gesler', 3, '1965-11-20', '489022353', null)
  104. Error report -
  105. ORA-01400: cannot insert NULL into ("S16766"."PERSON"."ADDITIONAL_CONTACT_INFO")
  106.  
  107.  
  108. Error starting at line : 32 in command -
  109. insert into Person values(
  110. 9, 'Omlet', 'Dufromage', 2, '1988-02-14', '304566782', 'mother 540098741')
  111. Error report -
  112. ORA-02291: integrity constraint (S16766.PERSON_COUNTRY) violated - parent key not found
  113.  
  114.  
  115. Error starting at line : 34 in command -
  116. insert into Person values(
  117. 10, 'Krzysztof', 'Krawczyk', 3, '1999-15-12', '135791470', 'Maryla 963974185')
  118. Error report -
  119. ORA-01861: literal does not match format string
  120.  
  121.  
  122. Error starting at line : 36 in command -
  123. insert into Person values(
  124. 11, 'Claus', 'Brown', 5, '1967-09-22', '699099521', null)
  125. Error report -
  126. ORA-01400: cannot insert NULL into ("S16766"."PERSON"."ADDITIONAL_CONTACT_INFO")
  127.  
  128.  
  129. Error starting at line : 38 in command -
  130. insert into Person values(
  131. 12, 'Fatema', 'Chamberlain', 1, '1980-09-04', '603730302', null)
  132. Error report -
  133. ORA-01400: cannot insert NULL into ("S16766"."PERSON"."ADDITIONAL_CONTACT_INFO")
  134.  
  135.  
  136. Error starting at line : 40 in command -
  137. insert into Person values(
  138. 13, 'Waqas', 'Rankin', 4, '1984-11-13', '666259423', null)
  139. Error report -
  140. ORA-01400: cannot insert NULL into ("S16766"."PERSON"."ADDITIONAL_CONTACT_INFO")
  141.  
  142.  
  143. Error starting at line : 42 in command -
  144. insert into Person values(
  145. 14, 'Kareena', 'Hibbert', 2, '1997-08-29', '884370683', null)
  146. Error report -
  147. ORA-01400: cannot insert NULL into ("S16766"."PERSON"."ADDITIONAL_CONTACT_INFO")
  148.  
  149.  
  150. Error starting at line : 46 in command -
  151. insert into Genre values(
  152. 1, 'Pop', null)
  153. Error report -
  154. ORA-01400: cannot insert NULL into ("S16766"."GENRE"."DERIVES_FROM")
  155.  
  156.  
  157. Error starting at line : 48 in command -
  158. insert into Genre values(
  159. 2, 'Rock', 3)
  160. Error report -
  161. ORA-02291: integrity constraint (S16766.GENRE_GENRE) violated - parent key not found
  162.  
  163.  
  164. Error starting at line : 50 in command -
  165. insert into Genre values(
  166. 3, 'Blues', null)
  167. Error report -
  168. ORA-01400: cannot insert NULL into ("S16766"."GENRE"."DERIVES_FROM")
  169.  
  170.  
  171. Error starting at line : 52 in command -
  172. insert into Genre values(
  173. 4, 'Jazz', null)
  174. Error report -
  175. ORA-01400: cannot insert NULL into ("S16766"."GENRE"."DERIVES_FROM")
  176.  
  177.  
  178. Error starting at line : 55 in command -
  179. insert into Band values(
  180. 1, 'The oven', 4, '1990-03-02', 3)
  181. Error report -
  182. ORA-02291: integrity constraint (S16766.BAND_GENRE) violated - parent key not found
  183.  
  184.  
  185. Error starting at line : 57 in command -
  186. insert into Band values(
  187. 2, 'Mystery', 2, '1995-04-20', 1)
  188. Error report -
  189. ORA-02291: integrity constraint (S16766.BAND_GENRE) violated - parent key not found
  190.  
  191.  
  192. Error starting at line : 59 in command -
  193. insert into Band values(
  194. 3, 'Fortune', 3, '2016-09-13', 4)
  195. Error report -
  196. ORA-02291: integrity constraint (S16766.BAND_GENRE) violated - parent key not found
  197.  
  198.  
  199. Error starting at line : 61 in command -
  200. insert into Band values(
  201. 4, 'Lovers from Mars', 1, '1990-03-02', 5)
  202. Error report -
  203. ORA-02291: integrity constraint (S16766.BAND_GENRE) violated - parent key not found
  204.  
  205.  
  206. 1 row inserted.
  207.  
  208.  
  209. 1 row inserted.
  210.  
  211.  
  212. 1 row inserted.
  213.  
  214.  
  215. 1 row inserted.
  216.  
  217.  
  218. 1 row inserted.
  219.  
  220.  
  221. 1 row inserted.
  222.  
  223.  
  224. Error starting at line : 78 in command -
  225. insert into Musician values(
  226. 1, 1, 4, 5)
  227. Error report -
  228. ORA-02291: integrity constraint (S16766.MUSICIAN_PERSON) violated - parent key not found
  229.  
  230.  
  231. Error starting at line : 80 in command -
  232. insert into Musician values(
  233. 2, 2, 4, 1)
  234. Error report -
  235. ORA-02291: integrity constraint (S16766.MUSICIAN_PERSON) violated - parent key not found
  236.  
  237.  
  238. Error starting at line : 82 in command -
  239. insert into Musician values(
  240. 3, 5, 2, 3)
  241. Error report -
  242. ORA-02291: integrity constraint (S16766.MUSICIAN_PERSON) violated - parent key not found
  243.  
  244.  
  245. Error starting at line : 84 in command -
  246. insert into Musician values(
  247. 4, 6, 2, 6)
  248. Error report -
  249. ORA-02291: integrity constraint (S16766.MUSICIAN_PERSON) violated - parent key not found
  250.  
  251.  
  252. Error starting at line : 86 in command -
  253. insert into Musician values(
  254. 5, 3, 3, 4)
  255. Error report -
  256. ORA-02291: integrity constraint (S16766.MUSICIAN_PERSON) violated - parent key not found
  257.  
  258.  
  259. Error starting at line : 88 in command -
  260. insert into Musician values(
  261. 6, 4, 3, 1)
  262. Error report -
  263. ORA-02291: integrity constraint (S16766.MUSICIAN_PERSON) violated - parent key not found
  264.  
  265.  
  266. Error starting at line : 90 in command -
  267. insert into Musician values(
  268. 7, 8, 1, 2)
  269. Error report -
  270. ORA-02291: integrity constraint (S16766.MUSICIAN_PERSON) violated - parent key not found
  271.  
  272.  
  273. Error starting at line : 92 in command -
  274. insert into Musician values(
  275. 8, 9, 1, 6)
  276. Error report -
  277. ORA-02291: integrity constraint (S16766.MUSICIAN_PERSON) violated - parent key not found
  278.  
  279.  
  280. Error starting at line : 95 in command -
  281. insert into Support values(
  282. 1, 14, 'sound tester')
  283. Error report -
  284. ORA-02291: integrity constraint (S16766.SUPPORT_PERSON) violated - parent key not found
  285.  
  286.  
  287. Error starting at line : 97 in command -
  288. insert into Support values(
  289. 2, 12, 'instrument specialist')
  290. Error report -
  291. ORA-02291: integrity constraint (S16766.SUPPORT_PERSON) violated - parent key not found
  292.  
  293.  
  294. Error starting at line : 100 in command -
  295. insert into Venue values(
  296. 1, 'Jazzhouse Paris', 'Broadcast Drive', 2)
  297. Error report -
  298. ORA-02291: integrity constraint (S16766.VENUE_COUNTRY) violated - parent key not found
  299.  
  300.  
  301. Error starting at line : 102 in command -
  302. insert into Venue values(
  303. 2, 'Rock and Roll club', 'Everette Alley', 5)
  304. Error report -
  305. ORA-02291: integrity constraint (S16766.VENUE_COUNTRY) violated - parent key not found
  306.  
  307.  
  308. Error starting at line : 105 in command -
  309. insert into Concert values(
  310. 1, 1, 'Elitist Convention', '2018-06-21 18:00:00', 2)
  311. Error report -
  312. ORA-02291: integrity constraint (S16766.CONCERT_VENUE) violated - parent key not found
  313.  
  314.  
  315. Error starting at line : 107 in command -
  316. insert into Concert values(
  317. 2, 2, 'The Crazy Show', '2018-07-30 22:00:00', 3)
  318. Error report -
  319. ORA-02291: integrity constraint (S16766.CONCERT_VENUE) violated - parent key not found
  320.  
  321.  
  322. Error starting at line : 110 in command -
  323. insert into Band_Playing_Concert values(
  324. 1, 2, 4, 500)
  325. Error report -
  326. ORA-02291: integrity constraint (S16766.BAND_PLAYING_CONCERT_CONCERT) violated - parent key not found
  327.  
  328.  
  329. Error starting at line : 112 in command -
  330. insert into Band_Playing_Concert values(
  331. 2, 2, 2, 500)
  332. Error report -
  333. ORA-02291: integrity constraint (S16766.BAND_PLAYING_CONCERT_CONCERT) violated - parent key not found
  334.  
  335.  
  336. Error starting at line : 114 in command -
  337. insert into Band_Playing_Concert values(
  338. 3, 1, 3, 200)
  339. Error report -
  340. ORA-02291: integrity constraint (S16766.BAND_PLAYING_CONCERT_CONCERT) violated - parent key not found
  341.  
  342.  
  343. Error starting at line : 116 in command -
  344. insert into Band_Playing_Concert values(
  345. 4, 1, 1, 300)
  346. Error report -
  347. ORA-02291: integrity constraint (S16766.BAND_PLAYING_CONCERT_CONCERT) violated - parent key not found
  348.  
  349.  
  350. Error starting at line : 119 in command -
  351. insert into Support_Staff values(
  352. 1, 1, 3, 100)
  353. Error report -
  354. ORA-02291: integrity constraint (S16766.SUPPORT_STAFF_SUPPORT) violated - parent key not found
  355.  
  356.  
  357. Error starting at line : 121 in command -
  358. insert into Support_Staff values(
  359. 2, 2, 2, 50)
  360. Error report -
  361. ORA-02291: integrity constraint (S16766.SUPPORT_STAFF_SUPPORT) violated - parent key not found
  362.  
  363.  
  364. 1 row inserted.
  365.  
  366.  
  367. Error starting at line : 126 in command -
  368. insert into Ticket_type values(
  369. 2, 20)
  370. Error report -
  371. ORA-01438: value larger than specified precision allowed for this column
  372.  
  373.  
  374. Error starting at line : 128 in command -
  375. insert into Ticket_type values(
  376. 3, 50)
  377. Error report -
  378. ORA-01438: value larger than specified precision allowed for this column
  379.  
  380.  
  381. Error starting at line : 131 in command -
  382. insert into Ticket values(
  383. 1, 1, 20, 11, 1)
  384. Error report -
  385. ORA-02291: integrity constraint (S16766.TICKET_PERSON) violated - parent key not found
  386.  
  387.  
  388. Error starting at line : 133 in command -
  389. insert into Ticket values(
  390. 2, 2, 25, 7, 3)
  391. Error report -
  392. ORA-02291: integrity constraint (S16766.TICKET_TICKET_TYPE) violated - parent key not found
  393.  
  394.  
  395. Error starting at line : 135 in command -
  396. insert into Ticket values(
  397. 3, 2, 25, 13, 2)
  398. Error report -
  399. ORA-02291: integrity constraint (S16766.TICKET_TICKET_TYPE) violated - parent key not found
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement