This content has been marked as final. Show 5 replies
An OTN forum search later :
Whats the main difference between a unique key constraint and a primary key constraint?
Which is better for large partitioned tables in a data warehouse environment.
Unique key means it allows uniques values only... which means nulls too because according to Oracle each null is different from other.
Primary key means the combination of Unique key and Not null constraint.
I dont know much of dataware housing problems.... but as far as i have seen the Oracle Apps tables always use Primary key to Unique key