| Error table is not working in OWB ? [message #485782] |
Thu, 09 December 2010 21:45  |
oravijay
Messages: 43
Registered: March 2010
|
Member |
|
|
javascript: insertTag(document.post_form.msg_body, '', '  ');
Dear Oracle Experts,
I new to oracle OWB.
Platform Oracle 11gr2 in centos linux
i have created a new mapping which transfers the data between two schemas.when I deploy i didnt face any errors and when i run the mapping it shows log
ORA-00001 unique constraint (RAHS2MIG1.PK_OBJECT) VOILATED.
IS it possible to record this message in Error table? Please if any one know how to record the error in error table.
I can only able to edit dml error table name box in property inspector but i cannot able to edit error table name.
Thanks in Advance,
Regards
Vijay
[Updated on: Thu, 09 December 2010 21:46] Report message to a moderator |
|
|
|
| Re: Error table is not working in OWB ? [message #485783 is a reply to message #485782] |
Thu, 09 December 2010 21:54  |
oravijay
Messages: 43
Registered: March 2010
|
Member |
|
|
Hi All,,
I have created the error table with the sql
SQL> connect rahs2mig1/rahs2mig1
Connected.
begin
dbms_errlog.create_error_log('migrationinfo','ERROR$_MIG') ;
end;
/
PL/SQL procedure successfully completed.
I have created the table ERROR$_MIG for the target schema object migrationinfo.After clicking the start option in the mapping.
ORA-00001 unique constraint (RAHS2MIG1.PK_OBJECT) VOILATED. error shows only in the log.
No errors record in the ERROR$_MIG table.
Please advise.
Thanks in Advance
Regards,
Vijay
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
