Hi there,
I'm working on database management homework and I'm having the issue on several of the questions... I'll start with one of them because hopefully once one is answered, all the rest will make sense.Â
I'm asked to ensure 'CustomerNum' is a foreign key in the 'Reservation' table. When running the following query:Â
ALTER TABLE Reservation
ADD FOREIGN KEY (CustomerNum)
REFERENCES Customer(CustomerNum);
I'm given an error report of ORA-02275: such a referential constraint already exists in the table.
So I tried dropping the constraint with the following:
ALTER TABLE Reservation
DROP CONSTRAINT CustomerNum;
Which gives me an error report of ORA-02443: Cannot drop constraint - nonexistent constraint.
I found something 'StackOverflow' that talked about possible indexes being named the same and interfering with the commands, but I don't see any indexes with the same names.Â
I have five of these problems that are all giving me the same errors. If I need to give more information or send along the code or anything let me know. I'm in Oracle.
I appreciate any help you can offer.
Manda
Answers
Status NEW
Posted 02 May 2017 08:05 AM
My Price 8.00
-----------
Attachments
file 1493713757-Solutions file 2.docx preview (51 words )
H-----------ell-----------o S-----------ir/-----------Mad-----------am
-----------
Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------.
-----------
Th-----------ank----------- yo-----------u
-----------
Not Rated(0)