Error on the primary key with the constraint

Author Name Status Posted Time Hilda Wasah 1/15/2008 11:24:55 PM Author is Offline Hi all, This is a school related question. My lab says the following: 1. Add a new Vendor table a. See table above for fields and data types b. Use your username as the table definition, i.e., userid.Vendor, instead of Demo c. Add Primary key ProductNo as a Constraint Okay, I created the table with the fields and data types. Now when I go to add the primary key with the constraint and I get ERROR at line 2: ORA-00904: "VENDOR_NO": invalid identifier When I enter: Code: ( oracle8 ) ALTER TABLE slp5065.vendor ADD                               CONSTRAINT ProductNo PRIMARY KEY (Vendor_No); This is the command the teacher listed on the paper: Code: ( oracle8 ) ALTER tables:     Adding a single field AS a PRIMARY KEY         ALTER TABLE tablename ADD                               CONSTRAINT pk_name PRIMARY KEY (column_name); What am I doing wrong?

Subject Author Status Date Re: Error on the primary key with the constraint Zebastti Tottileit 1/17/2008 1:34:07 AM Moved to Oracle Forum. Checkout this post. Post Comments Re: Error on the primary key with the constraint Hesus Oliver Pecce 1/17/2008 1:36:48 AM Please post your table structure for reference? Post Comments Re: I see my dumb error on that one Hilda Wasah 1/17/2008 1:43:31 AM I see my dumb error on that one. But I am having a problem with the foreign key. My paper says: 3. Alter Vendor table to add constraint of Vendor.Zip_Code as a Foreign Key field references Zipcode.Zip_code field. Code: ( text ) ALTER TABLE tablename ADD                               CONSTRAINT fk_name FOREIGN KEY (column_name)                               REFERENCES tablename (column_name); I typed in: Code: ( text ) ALTER TABLE slp5065.vendor ADD                               CONSTRAINT slp5065.vendor.zip_code FOREIGN KEY (vendor_zip_code)                               REFERENCES slp5065.zipcode.zip_code (zip_code); I got the error: CONSTRAINT slp5065.vendor.zip_code FOREIGN KEY (vendor_zip_code) * ERROR at line 2: ORA-00904: : invalid identifier Post Comments Re: First tell me in your query Helen Deol 1/17/2008 1:53:12 AM hi, First tell me in your query what is following...... Code: ( text ) ALTER TABLE slp5065.vendor ADD                               CONSTRAINT slp5065.vendor.zip_code FOREIGN KEY (vendor_zip_code)                               REFERENCES slp5065.zipcode.zip_code (zip_code); It should be tablename contains the column you are referencing as foreign key... From your code it seems that you have two tables named slp5065.vendor and slp5065.zipcode and if i'm not wrong change your query to this.. Code: ( oracle8 ) ALTER TABLE slp5065.vendor ADD                               CONSTRAINT slp5065.vendor.zip_code FOREIGN KEY (vendor_zip_code)                               REFERENCES slp5065.zipcode(zip_code); As per my knwoledge...... If i'm wrong somewhere let me know........ Regards, Post Comments Re: Can anyone help? Hilda Wasah 1/17/2008 1:45:20 AM Can anyone help? I have to turn it in by midnight est. Which is in 38 minutes. I e-mailed my te acher about this a while ago and he hasn't gotten back to me. Post Comments Re: Please let me know the following Hesus Oliver Pecce 1/17/2008 1:46:51 AM Please let me know the following: What is slp5065?? a schema name? What is Zipcode?? a table name?? And I dont find your table structure.Please POST your table structure. Post Comments Re: Sorry very new to Oracle and all Hilda Wasah 1/17/2008 1:48:11 AM Sorry very new to Oracle and all. slp5065 is my user name. When we did other projects for the c lass they were named demo.customer. So for each student we had to just put our userid.tablename . slp5065.Zipcode is a table. I guess this is the table structure. If it isn't please let m e know and I will try to find out what it is. Post Comments Re: Thank you for the reply Hilda Wasah 1/17/2008 1:54:49 AM Thank you for the reply. I tried what you said and I got the following error: CONSTRAINT slp5065.vendor.zip_code FOREIGN KEY (vendor_zip_code) * ERROR at line 2: ORA-00904: : invalid identifier Post Comments Re: Do the following Hesus Oliver Pecce 1/17/2008 1:55:36 AM Do the following and paste the output here: Code: ( oracle8 ) SQL> DESC <table_name> In the above code replace table_name with your table name and paste the output here for my reference Post Comments Re: slp5065.vendor table Hilda Wasah 1/17/2008 1:56:51 AM slp5065.vendor table Name Null? Type VENDOR_NO NOT NULL NUMBER(6) VENDOR_NAME VARCHAR2(30) VENDOR_ADDRESS VARCHAR2(35) VENDOR_ZIP_CODE NOT NULL NUMBER(38) slp5065.zipcode table Name Null? Type ZIP_CODE NOT NULL NUMBER(5) ZIP_CITY VARCHAR2(15) ZIP_STATE VARCHAR2(2) Post Comments Re: Try this Hesus Oliver Pecce 1/17/2008 1:57:59 AM Try this: Code: ( oracle8 ) ALTER TABLE vendor_table ADD FOREIGN KEY (vendor_zip_code) REFERENCES zipcode(zip_code); Post Comments Re: Error on the primary key with the constraint Hesus Oliver Pecce 1/17/2008 1:42:44 AM Sorry about posting it in the wrong forum. Post Comments

Related Forums Optimizing Images Get a Website Template for Free!!! Get a Website Template for Free!!! Reply to Hesus!!! Do You Sell Your Templates on Ebay?