By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,254 Members | 1,713 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,254 IT Pros & Developers. It's quick & easy.

Mandatory one to mandatory many relationship

P: 4
Hello! I have Contract and Rent_Payment. I want to make it mandatory one to mandatory many so that a Contract must have one or more Rent_Payments.
I understand that after I create both tables, I then use

How do I deal with this?

I figured it out! Cant figure out how to delete though...
Dec 11 '14 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,430
We would need the commands you are running that produce the error, the full error message, and the full data definition language for the tables involved.
Dec 11 '14 #2

P: 4
This is the error:
Error report -
SQL Error: ORA-01758: table must be empty to add mandatory (NOT NULL) column
01758. 00000 - "table must be empty to add mandatory (NOT NULL) column"
*Cause:
*Action:
Dec 12 '14 #3

Rabbit
Expert Mod 10K+
P: 12,430
And the rest of the information I asked for?

But the error message itself is helpful. It's pretty self explanatory. It says the table can't have any data if you want to add a not null field.
Dec 12 '14 #4

Post your reply

Sign in to post your reply or Sign up for a free account.