473,385 Members | 1,326 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Mandatory one to mandatory many relationship

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
3 1898
Rabbit
12,516 Expert Mod 8TB
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
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
12,516 Expert Mod 8TB
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

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

Similar topics

6
by: Frans Englich | last post by:
Hello, In my use of getopt.getopt, I would like to make a certain parameter mandatory. I know how to specify such that a parameter must have a value if it's specified, but I also want to make...
1
by: Chris West | last post by:
I have an schema that defines an element as mandatory, but I also want the XML instance to have some content for that mandatory element. I can use a regular expression to guarantee content, but...
2
by: Bangalore | last post by:
Hi, Plz, clarify me , with the differences between advisory lock and mandatory locks. Thnanks in advance Bangalore.
4
by: Mike MacSween | last post by:
Production (one) to events (many) Events must have a production (easy, non null FK) A Production doesn't make (business) sense without an event. How to enforce a mandatory relationship on the...
1
by: Le Tubs | last post by:
Hi I am wondering if anybody has come accross this problem before, basically I have to validate a xml schema (not the data, this is done at a later stage). The only problem is that there are...
6
by: Ruso | last post by:
I have this function, which should change a value of the texfield(s) depending on the radio buttons selection. function foo(obj) { if (!array) { flag++; } if (array != obj.value ) {...
4
by: plumba | last post by:
Let me explain.... I have a form (most of which you guys have helped me with!!). The initial problem I was having is that it was holding the data in the fields after submit, I resolved this by...
2
by: AR123 | last post by:
Hi I have set up a form. What I want to to is with the fields: Company Postcode Agency Number Policy Number I want these to be mandatory however if someone fills in the company postcode for...
1
by: chriscarllewis2012 | last post by:
Hey - I'm designing the relationships between some tables in Access and am looking for a little guidance - The part I'm struggling with: I have four tables, Inspections...
2
by: BD | last post by:
I'm working with a data model which is managed in the AllFusion ERwin tool. Within the modeler, some of the FK relationships are 'non-mandatory' - which is to say that for a given child value, a...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.