Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Not null in composite key?

443808Jul 13 2005 — edited Jul 19 2005
I created one table as:


create table abc
(f_name varchar2(50),
m_name varchar2(50),
l_name varchar2(50),
CONSTRAINT UK_NAME UNIQUE (f_name,l_name,m_name)
)

Here I want to keep NOT NULL Constraint on the composite key. Something like


CONSTRAINT NOTNULL_NAME NOT NULL (f_name,l_name,m_name)

How to do this?

Regds,
Ashish

Comments

Gianni Ceresa

And the context is?
Where are you running that? Did it ever work? What did you install in that place to have the "datamodel.sh" file?

1 person found this helpful
Joel Acha

Have you done an rpd consistency check beforehand? Also, can you try running your command with a blank rpd?

User_CN4UP

It worked once and again giving error.
i am running upload command in the path where we have datamodel.sh

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 16 2005
Added on Jul 13 2005
#general-database-discussions
10 comments
412 views