|
-
add constraint problem
Hi,
I am trying to add constraint, and getting this error.
SQL> alter table ap6.ap_invoices_all
add constraint up_inv_num check(invoice_num = upper invoice_num));
ERROR at line 2:
ORA-02293: cannot enable (AP6.UP_INV_NUM) - check constraint violated
Hintts- The table is already populated. Is this could be the reason?
Thanks in advance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|