unique constraints

[holdingbe]

Hi all,

I created one table with only one primary constraints.whe n i inserted data into that table.It shows the unique constraints errors.after i check any duplicate
data present in the table but no duplicate data are present in the tables.I capture the unique constarints name and check in the data
dictionary tables like user_constraint s.that name not present in the data dictionary.but the same table are created in other schema and imported same data but no error occured...

please help me..

[debasisdas]

dictionary tables like user_constraint s shows constraints on tables of current user only, not of other users. and if u copy the structure of a table from another table in same or another schema only the simple structure and data is copied not the constraints.