Oracle Configuration in DBMS Assignment

Added on - Sep 2019

Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 4 of 16 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 object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 11 in command -
insert into project_type(ptype_id, ptype_name) values (1, 'Web')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 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 see
this 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 -
insert into project_type(ptype_id, ptype_name) values (2, 'Maintenance')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 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 see
this 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 : 15 in command -
insert into project_type(ptype_id, ptype_name) values (3, 'App')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 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 see
this 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 : 17 in command -
insert into project_type(ptype_id, ptype_name) values (4, 'Testing')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 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 see
this 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 : 19 in command -
create table project
(
Project_id varchar(10) primary key,
Project_Name varchar(100),
Project_Type_id integer,
Start_Date date,
End_Date date,
expect_finish_date date,
constraint p_fk foreign key(Project_Type_id) references Project_Type(ptype_id)
)
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 : 39 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',
'39;2016-09- 02')
Error report -
SQL Error: ORA-01861: literal does not match format string
01861. 00000 - "literal does not match format string"
*Cause:Literals in the input must be the same length as literals in
the 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 : 43 in command -
insert into project(Project_id, Project_Name, Project_Type_id, Start_Date, End_Date,
expect_finish_date) values ('B1050&#39', 'insurance System', 2, '39;2016-01- 01', '2016-03-
03', '2016-03- 06')
Error report -
SQL Error: ORA-01847: day of month must be between 1 and last day of month
01847. 00000 - "day of month must be between 1 and last day of month"
*Cause:
*Action:
Error starting at line : 49 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 string
01861. 00000 - "literal does not match format string"
*Cause:Literals in the input must be the same length as literals in
the 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 : 53 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 : 63 in command -
insert into job_type(type_id, type_name) values ('JT1', 'Imaging')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 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 see
this 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 : 65 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) violated
00001. 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 see
this 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 : 67 in command -
insert into job_type(type_id, type_name) values ('JT3', 'Maintenance')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 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 see
this 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 : 69 in command -
insert into job_type(type_id, type_name) values ('JT4', 'Training')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 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 see
this 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 : 71 in command -
create table Staff
(
Staff_ID varchar(10) primary key,
Name varchar(50),
Job_Type_id varchar(5),
Job_Grade integer,
constraint s_fk foreign key(job_type_id) references Job_type(type_id)
)
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 : 87 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('1014E', 'John Baker',
'JT1', 3)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 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 see
this 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 : 89 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('230R1', 'Marian Dowd',
'JT2', 1)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 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 see
this 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 : 91 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('0P625', 'Jennifer Tuff',
'JT3', 2)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 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 see
this 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 : 93 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('4T371', 'Paul Downing',
'JT4', 3
)
Error report -
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 object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
Error starting at line : 11 in command -
insert into project_type(ptype_id, ptype_name) values (1, 'Web')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 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 see
this 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 -
insert into project_type(ptype_id, ptype_name) values (2, 'Maintenance')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 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 see
this 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 : 15 in command -
insert into project_type(ptype_id, ptype_name) values (3, 'App')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 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 see
this 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 : 17 in command -
insert into project_type(ptype_id, ptype_name) values (4, 'Testing')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated
00001. 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 see
this 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 : 19 in command -
create table project
(
Project_id varchar(10) primary key,
Project_Name varchar(100),
Project_Type_id integer,
Start_Date date,
End_Date date,
expect_finish_date date,
constraint p_fk foreign key(Project_Type_id) references Project_Type(ptype_id)
)
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 : 39 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',
'39;2016-09- 02')
Error report -
SQL Error: ORA-01861: literal does not match format string
01861. 00000 - "literal does not match format string"
*Cause:Literals in the input must be the same length as literals in
the 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 : 43 in command -
insert into project(Project_id, Project_Name, Project_Type_id, Start_Date, End_Date,
expect_finish_date) values ('B1050&#39', 'insurance System', 2, '39;2016-01- 01', '2016-03-
03', '2016-03- 06')
Error report -
SQL Error: ORA-01847: day of month must be between 1 and last day of month
01847. 00000 - "day of month must be between 1 and last day of month"
*Cause:
*Action:
Error starting at line : 49 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 string
01861. 00000 - "literal does not match format string"
*Cause:Literals in the input must be the same length as literals in
the 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 : 53 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 : 63 in command -
insert into job_type(type_id, type_name) values ('JT1', 'Imaging')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 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 see
this 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 : 65 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) violated
00001. 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 see
this 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 : 67 in command -
insert into job_type(type_id, type_name) values ('JT3', 'Maintenance')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 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 see
this 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 : 69 in command -
insert into job_type(type_id, type_name) values ('JT4', 'Training')
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated
00001. 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 see
this 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 : 71 in command -
create table Staff
(
Staff_ID varchar(10) primary key,
Name varchar(50),
Job_Type_id varchar(5),
Job_Grade integer,
constraint s_fk foreign key(job_type_id) references Job_type(type_id)
)
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 : 87 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('1014E', 'John Baker',
'JT1', 3)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 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 see
this 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 : 89 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('230R1', 'Marian Dowd',
'JT2', 1)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 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 see
this 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 : 91 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('0P625', 'Jennifer Tuff',
'JT3', 2)
Error report -
SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024806) violated
00001. 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 see
this 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 : 93 in command -
insert into staff(Staff_id, name, Job_Type_id, Job_Grade) values ('4T371', 'Paul Downing',
'JT4', 3
)
Error report -
Desklib Logo
You are reading a preview
Upload your documents to download or

Become a Desklib member to get access