Oracle Database Assignment | DBMS

Added on - 16 Sep 2019

  • Dissertation

    type

  • 7

    pages

  • 3576

    words

  • 30

    views

  • 0

    downloads

Showing pages 1 to 3 of 7 pages
Error starting at line : 1 in command -create table Project_Type(ptype_id integer primary key,ptype_name varchar(50))Error report -SQL Error: ORA-00955: name is already used by an existing object00955. 00000 - "name is already used by an existing object"*Cause:*Action:Error starting at line : 7 in command -insert into project_type(ptype_id, ptype_name) values (1, 'Web')Error report -SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated00001. 00000 - "unique constraint (%s.%s) violated"*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.For Trusted Oracle configured in DBMS MAC mode, you may seethis message if a duplicate entry exists at a different level.*Action: Either remove the unique restriction or do not insert the key.Error starting at line : 8 in command -insert into project_type(ptype_id, ptype_name) values (2, 'Maintenance')Error report -SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated00001. 00000 - "unique constraint (%s.%s) violated"*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.For Trusted Oracle configured in DBMS MAC mode, you may seethis message if a duplicate entry exists at a different level.*Action: Either remove the unique restriction or do not insert the key.Error starting at line : 9 in command -insert into project_type(ptype_id, ptype_name) values (3, 'App')Error report -SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated00001. 00000 - "unique constraint (%s.%s) violated"*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.For Trusted Oracle configured in DBMS MAC mode, you may seethis message if a duplicate entry exists at a different level.*Action: Either remove the unique restriction or do not insert the key.Error starting at line : 10 in command -insert into project_type(ptype_id, ptype_name) values (4, 'Testing')Error report -SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated00001. 00000 - "unique constraint (%s.%s) violated"*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.For Trusted Oracle configured in DBMS MAC mode, you may seethis message if a duplicate entry exists at a different level.*Action: Either remove the unique restriction or do not insert the key.Error starting at line : 13 in command -create table project(Project_idvarchar(10) primary key,Project_Namevarchar(100),
Project_Type_id integer,Start_Date date,End_Date date,expect_finish_date date,constraintp_fk foreign key(Project_Type_id) references Project_Type(ptype_id))Error report -SQL Error: ORA-00902: invalid datatype00902. 00000 - "invalid datatype"*Cause:*Action:Error starting at line : 24 in command -insert into project(Project_id, Project_Name, Project_Type_id, Start_Date, End_Date,expect_finish_date) values ('B1049', 'Health System', 1, '2016-06-01', '2016-09-01', '2016-09-02')Error report -SQL Error: ORA-01861: literal does not match format string01861. 00000 - "literal does not match format string"*Cause: Literals in the input must be the same length as literals inthe format string (with the exception of leading whitespace). If the"FX" modifier has been toggled on, the literal must match exactly,with no extra whitespace.*Action: Correct the format string to match the literal.Error starting at line : 26 in command -insert into project(Project_id, Project_Name, Project_Type_id, Start_Date, End_Date,expect_finish_date) values ('B1050', 'insurance System', 2, '2016-01-01', '2016-03-03', '2016-03-06')Error report -SQL Error: ORA-01861: literal does not match format string01861. 00000 - "literal does not match format string"*Cause: Literals in the input must be the same length as literals inthe format string (with the exception of leading whitespace). If the"FX" modifier has been toggled on, the literal must match exactly,with no extra whitespace.*Action: Correct the format string to match the literal.Error starting at line : 28 in command -insert into project(Project_id, Project_Name, Project_Type_id, Start_Date, End_Date,expect_finish_date) values ('B1051', 'university System', 3, '2016-05-01', '2016-06-01', '2016-06-05')Error report -SQL Error: ORA-01861: literal does not match format string01861. 00000 - "literal does not match format string"*Cause: Literals in the input must be the same length as literals inthe format string (with the exception of leading whitespace). If the"FX" modifier has been toggled on, the literal must match exactly,with no extra whitespace.*Action: Correct the format string to match the literal.Error starting at line : 30 in command -create table Job_type(type_id varchar(5) primary key,type_name varchar(50))Error report -SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"*Cause:*Action:Error starting at line : 36 in command -insert into job_type(type_id, type_name) values ('JT1', 'Imaging')Error report -SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated00001. 00000 - "unique constraint (%s.%s) violated"*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.For Trusted Oracle configured in DBMS MAC mode, you may seethis message if a duplicate entry exists at a different level.*Action: Either remove the unique restriction or do not insert the key.Error starting at line : 37 in command -insert into job_type(type_id, type_name) values ('JT2', 'Web Developer')Error report -SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated00001. 00000 - "unique constraint (%s.%s) violated"*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.For Trusted Oracle configured in DBMS MAC mode, you may seethis message if a duplicate entry exists at a different level.*Action: Either remove the unique restriction or do not insert the key.Error starting at line : 38 in command -insert into job_type(type_id, type_name) values ('JT3', 'Maintenance')Error report -SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated00001. 00000 - "unique constraint (%s.%s) violated"*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.For Trusted Oracle configured in DBMS MAC mode, you may seethis message if a duplicate entry exists at a different level.*Action: Either remove the unique restriction or do not insert the key.Error starting at line : 39 in command -insert into job_type(type_id, type_name) values ('JT4', 'Training')Error report -SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated00001. 00000 - "unique constraint (%s.%s) violated"*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.For Trusted Oracle configured in DBMS MAC mode, you may seethis message if a duplicate entry exists at a different level.*Action: Either remove the unique restriction or do not insert the key.Error starting at line : 42 in command -create table Staff(Staff_IDvarchar(10) primary key,Name varchar(50),Job_Type_idvarchar(5),Job_Grade integer,constraints_fk foreign key(job_type_id) references Job_type(type_id))Error report -SQL Error: ORA-00902: invalid datatype00902. 00000 - "invalid datatype"*Cause:
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Unlock This Document