Re: foreign key rule error

victorrhee <member_at_dbforums.com> wrote in message news:<1958214.1035301651_at_dbforums.com>...
> Thanks Daniel and Vitaliy
>
> Daniel, I appreciate your comments and must admit I'm very confused. My
> earlier attempts to research the problem took me to C J Date's textbook
> "An Introduction to Database Systems" (25th Ed.) where I followed the
> example on page 269. This also confirmed my class notes, however the
> code wouldn't process. I did finally get the table created by only
> including one 'referential action' (in this case "on delete cascade") in
> each foreign key statement.
>
> I'm 3 months into my Information Systems subject and the terms "PCTFREE,
> PCTUSED, INITIAL, NEXT" are not known to me. Daniel, I would be grateful
> if you could recommend reference material that expands on your comments
> about creating tables.
>
> Vitaliy, I must admit I had included the fields in one of my previous
> attempts. I understood that a referencing field was only required if the
> foreign key references a candidate key that is NOT a primary key of the
> parent table. Am I wrong, or do I need to find another lecturer
> ........ did I mention I was confused?
>
> Thanks again for your responses
> Vic

To me consulting the Oracle SQL reference , online at http://tahiti.oracle.com is rather obvious. Apparently you assumed SQL is vendor independent. Believe me, it is not.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Wed Oct 23 2002 - 02:42:44 CDT