Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Error starting at line : 4 in command -
- insert into Country values(
- 1, Hungary)
- Error at Command Line : 5 Column : 8
- Error report -
- SQL Error: ORA-00984: column not allowed here
- 00984. 00000 - "column not allowed here"
- *Cause:
- *Action:
- Error starting at line : 6 in command -
- insert into Country values(
- 2, France)
- Error at Command Line : 7 Column : 8
- Error report -
- SQL Error: ORA-00984: column not allowed here
- 00984. 00000 - "column not allowed here"
- *Cause:
- *Action:
- Error starting at line : 8 in command -
- insert into Country values(
- 3, Poland)
- Error at Command Line : 9 Column : 8
- Error report -
- SQL Error: ORA-00984: column not allowed here
- 00984. 00000 - "column not allowed here"
- *Cause:
- *Action:
- Error starting at line : 10 in command -
- insert into Country values(
- 4, England)
- Error at Command Line : 11 Column : 8
- Error report -
- SQL Error: ORA-00984: column not allowed here
- 00984. 00000 - "column not allowed here"
- *Cause:
- *Action:
- Error starting at line : 12 in command -
- insert into Country values(
- 5, German)
- Error at Command Line : 13 Column : 8
- Error report -
- SQL Error: ORA-00984: column not allowed here
- 00984. 00000 - "column not allowed here"
- *Cause:
- *Action:
- Error starting at line : 16 in command -
- insert into Person values(
- 1, 'Bob', 'Ross', 1, '2000-01-01', '758473829', null)
- Error report -
- ORA-01400: cannot insert NULL into ("S16766"."PERSON"."ADDITIONAL_CONTACT_INFO")
- Error starting at line : 18 in command -
- insert into Person values(
- 2, 'Jeli', 'Papon', 2, '1973-10-16', '548391035', 'wife 504782287')
- Error report -
- ORA-02291: integrity constraint (S16766.PERSON_COUNTRY) violated - parent key not found
- Error starting at line : 20 in command -
- insert into Person values(
- 3, 'Count', 'Olaf', 5, '1953-12-24', '784020135', 'orphans 997998999')
- Error report -
- ORA-02291: integrity constraint (S16766.PERSON_COUNTRY) violated - parent key not found
- Error starting at line : 22 in command -
- insert into Person values(
- 4, 'Baudelaire', 'Orphans', 4, '2003-04-13', '997998999', null)
- Error report -
- ORA-01400: cannot insert NULL into ("S16766"."PERSON"."ADDITIONAL_CONTACT_INFO")
- Error starting at line : 24 in command -
- insert into Person values(
- 5, 'Scooby', 'Doo', 1, '1983-07-14', '560000813', 'Shaggy 098765432')
- Error report -
- ORA-02291: integrity constraint (S16766.PERSON_COUNTRY) violated - parent key not found
- Error starting at line : 26 in command -
- insert into Person values(
- 6, 'Shaggy', 'Doo', 1, '1983-07-15', '098765432', 'Scooby 560000813')
- Error report -
- ORA-02291: integrity constraint (S16766.PERSON_COUNTRY) violated - parent key not found
- Error starting at line : 28 in command -
- insert into Person values(
- 7, 'Sherlock', 'Holmes', 4, '1943-12-31', '667892047', 'dr Watson 112999991')
- Error report -
- ORA-02291: integrity constraint (S16766.PERSON_COUNTRY) violated - parent key not found
- Error starting at line : 30 in command -
- insert into Person values(
- 8, 'Magda', 'Gesler', 3, '1965-11-20', '489022353', null)
- Error report -
- ORA-01400: cannot insert NULL into ("S16766"."PERSON"."ADDITIONAL_CONTACT_INFO")
- Error starting at line : 32 in command -
- insert into Person values(
- 9, 'Omlet', 'Dufromage', 2, '1988-02-14', '304566782', 'mother 540098741')
- Error report -
- ORA-02291: integrity constraint (S16766.PERSON_COUNTRY) violated - parent key not found
- Error starting at line : 34 in command -
- insert into Person values(
- 10, 'Krzysztof', 'Krawczyk', 3, '1999-15-12', '135791470', 'Maryla 963974185')
- Error report -
- ORA-01861: literal does not match format string
- Error starting at line : 36 in command -
- insert into Person values(
- 11, 'Claus', 'Brown', 5, '1967-09-22', '699099521', null)
- Error report -
- ORA-01400: cannot insert NULL into ("S16766"."PERSON"."ADDITIONAL_CONTACT_INFO")
- Error starting at line : 38 in command -
- insert into Person values(
- 12, 'Fatema', 'Chamberlain', 1, '1980-09-04', '603730302', null)
- Error report -
- ORA-01400: cannot insert NULL into ("S16766"."PERSON"."ADDITIONAL_CONTACT_INFO")
- Error starting at line : 40 in command -
- insert into Person values(
- 13, 'Waqas', 'Rankin', 4, '1984-11-13', '666259423', null)
- Error report -
- ORA-01400: cannot insert NULL into ("S16766"."PERSON"."ADDITIONAL_CONTACT_INFO")
- Error starting at line : 42 in command -
- insert into Person values(
- 14, 'Kareena', 'Hibbert', 2, '1997-08-29', '884370683', null)
- Error report -
- ORA-01400: cannot insert NULL into ("S16766"."PERSON"."ADDITIONAL_CONTACT_INFO")
- Error starting at line : 46 in command -
- insert into Genre values(
- 1, 'Pop', null)
- Error report -
- ORA-01400: cannot insert NULL into ("S16766"."GENRE"."DERIVES_FROM")
- Error starting at line : 48 in command -
- insert into Genre values(
- 2, 'Rock', 3)
- Error report -
- ORA-02291: integrity constraint (S16766.GENRE_GENRE) violated - parent key not found
- Error starting at line : 50 in command -
- insert into Genre values(
- 3, 'Blues', null)
- Error report -
- ORA-01400: cannot insert NULL into ("S16766"."GENRE"."DERIVES_FROM")
- Error starting at line : 52 in command -
- insert into Genre values(
- 4, 'Jazz', null)
- Error report -
- ORA-01400: cannot insert NULL into ("S16766"."GENRE"."DERIVES_FROM")
- Error starting at line : 55 in command -
- insert into Band values(
- 1, 'The oven', 4, '1990-03-02', 3)
- Error report -
- ORA-02291: integrity constraint (S16766.BAND_GENRE) violated - parent key not found
- Error starting at line : 57 in command -
- insert into Band values(
- 2, 'Mystery', 2, '1995-04-20', 1)
- Error report -
- ORA-02291: integrity constraint (S16766.BAND_GENRE) violated - parent key not found
- Error starting at line : 59 in command -
- insert into Band values(
- 3, 'Fortune', 3, '2016-09-13', 4)
- Error report -
- ORA-02291: integrity constraint (S16766.BAND_GENRE) violated - parent key not found
- Error starting at line : 61 in command -
- insert into Band values(
- 4, 'Lovers from Mars', 1, '1990-03-02', 5)
- Error report -
- ORA-02291: integrity constraint (S16766.BAND_GENRE) violated - parent key not found
- 1 row inserted.
- 1 row inserted.
- 1 row inserted.
- 1 row inserted.
- 1 row inserted.
- 1 row inserted.
- Error starting at line : 78 in command -
- insert into Musician values(
- 1, 1, 4, 5)
- Error report -
- ORA-02291: integrity constraint (S16766.MUSICIAN_PERSON) violated - parent key not found
- Error starting at line : 80 in command -
- insert into Musician values(
- 2, 2, 4, 1)
- Error report -
- ORA-02291: integrity constraint (S16766.MUSICIAN_PERSON) violated - parent key not found
- Error starting at line : 82 in command -
- insert into Musician values(
- 3, 5, 2, 3)
- Error report -
- ORA-02291: integrity constraint (S16766.MUSICIAN_PERSON) violated - parent key not found
- Error starting at line : 84 in command -
- insert into Musician values(
- 4, 6, 2, 6)
- Error report -
- ORA-02291: integrity constraint (S16766.MUSICIAN_PERSON) violated - parent key not found
- Error starting at line : 86 in command -
- insert into Musician values(
- 5, 3, 3, 4)
- Error report -
- ORA-02291: integrity constraint (S16766.MUSICIAN_PERSON) violated - parent key not found
- Error starting at line : 88 in command -
- insert into Musician values(
- 6, 4, 3, 1)
- Error report -
- ORA-02291: integrity constraint (S16766.MUSICIAN_PERSON) violated - parent key not found
- Error starting at line : 90 in command -
- insert into Musician values(
- 7, 8, 1, 2)
- Error report -
- ORA-02291: integrity constraint (S16766.MUSICIAN_PERSON) violated - parent key not found
- Error starting at line : 92 in command -
- insert into Musician values(
- 8, 9, 1, 6)
- Error report -
- ORA-02291: integrity constraint (S16766.MUSICIAN_PERSON) violated - parent key not found
- Error starting at line : 95 in command -
- insert into Support values(
- 1, 14, 'sound tester')
- Error report -
- ORA-02291: integrity constraint (S16766.SUPPORT_PERSON) violated - parent key not found
- Error starting at line : 97 in command -
- insert into Support values(
- 2, 12, 'instrument specialist')
- Error report -
- ORA-02291: integrity constraint (S16766.SUPPORT_PERSON) violated - parent key not found
- Error starting at line : 100 in command -
- insert into Venue values(
- 1, 'Jazzhouse Paris', 'Broadcast Drive', 2)
- Error report -
- ORA-02291: integrity constraint (S16766.VENUE_COUNTRY) violated - parent key not found
- Error starting at line : 102 in command -
- insert into Venue values(
- 2, 'Rock and Roll club', 'Everette Alley', 5)
- Error report -
- ORA-02291: integrity constraint (S16766.VENUE_COUNTRY) violated - parent key not found
- Error starting at line : 105 in command -
- insert into Concert values(
- 1, 1, 'Elitist Convention', '2018-06-21 18:00:00', 2)
- Error report -
- ORA-02291: integrity constraint (S16766.CONCERT_VENUE) violated - parent key not found
- Error starting at line : 107 in command -
- insert into Concert values(
- 2, 2, 'The Crazy Show', '2018-07-30 22:00:00', 3)
- Error report -
- ORA-02291: integrity constraint (S16766.CONCERT_VENUE) violated - parent key not found
- Error starting at line : 110 in command -
- insert into Band_Playing_Concert values(
- 1, 2, 4, 500)
- Error report -
- ORA-02291: integrity constraint (S16766.BAND_PLAYING_CONCERT_CONCERT) violated - parent key not found
- Error starting at line : 112 in command -
- insert into Band_Playing_Concert values(
- 2, 2, 2, 500)
- Error report -
- ORA-02291: integrity constraint (S16766.BAND_PLAYING_CONCERT_CONCERT) violated - parent key not found
- Error starting at line : 114 in command -
- insert into Band_Playing_Concert values(
- 3, 1, 3, 200)
- Error report -
- ORA-02291: integrity constraint (S16766.BAND_PLAYING_CONCERT_CONCERT) violated - parent key not found
- Error starting at line : 116 in command -
- insert into Band_Playing_Concert values(
- 4, 1, 1, 300)
- Error report -
- ORA-02291: integrity constraint (S16766.BAND_PLAYING_CONCERT_CONCERT) violated - parent key not found
- Error starting at line : 119 in command -
- insert into Support_Staff values(
- 1, 1, 3, 100)
- Error report -
- ORA-02291: integrity constraint (S16766.SUPPORT_STAFF_SUPPORT) violated - parent key not found
- Error starting at line : 121 in command -
- insert into Support_Staff values(
- 2, 2, 2, 50)
- Error report -
- ORA-02291: integrity constraint (S16766.SUPPORT_STAFF_SUPPORT) violated - parent key not found
- 1 row inserted.
- Error starting at line : 126 in command -
- insert into Ticket_type values(
- 2, 20)
- Error report -
- ORA-01438: value larger than specified precision allowed for this column
- Error starting at line : 128 in command -
- insert into Ticket_type values(
- 3, 50)
- Error report -
- ORA-01438: value larger than specified precision allowed for this column
- Error starting at line : 131 in command -
- insert into Ticket values(
- 1, 1, 20, 11, 1)
- Error report -
- ORA-02291: integrity constraint (S16766.TICKET_PERSON) violated - parent key not found
- Error starting at line : 133 in command -
- insert into Ticket values(
- 2, 2, 25, 7, 3)
- Error report -
- ORA-02291: integrity constraint (S16766.TICKET_TICKET_TYPE) violated - parent key not found
- Error starting at line : 135 in command -
- insert into Ticket values(
- 3, 2, 25, 13, 2)
- Error report -
- ORA-02291: integrity constraint (S16766.TICKET_TICKET_TYPE) violated - parent key not found
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement