Hi
Iam learning informatica 8.1 ( which is what i could get my hands on)..

I am connecting to oracle 10g.
I created 2 connections to the DB using Connection --> Relational Connection Browser.
The Source and Target are the same db in this case, just diff table names. But created 2 separate connections .
I 1st created the TUTORIAL_SOURCE and then copied it to TUTORIAL_TARGET and gave it a new name.
then saved it
But when i try to retrieve now, for the TUTORIAL_TARGET I'm getting this.

DataBase error: ORA-01455: converting column overflows integer datatype ORA-01455: converting column overflows integer datatype Database driver error... Function Name : Fetch SQL Stmt : SELECT OBJECT_NAME, OBJECT_TYPE, OBJECT_SUBTYPE, USER_NAME, USER_PASSWORD2, CONNECT_STRING, CODE_PAGE, COMMENTS, OWNER_ID, GROUP_ID, LAST_SAVED, CREATE_INFO, OPB_OBJECT_ID, OBJVERSION, COMP_VERSION FROM OPB_CNX WHERE OBJECT_ID = ?

I can see some data in the table and I have an idea about the offending column
The structure of the table is

SQL> desc OPB_CNX ;
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
OBJECT_ID NUMBER
OBJECT_TYPE NUMBER
OBJECT_NAME VARCHAR2(240)
OBJECT_SUBTYPE NUMBER
USER_NAME VARCHAR2(240)
USER_PASSWORD VARCHAR2(240)
CONNECT_STRING VARCHAR2(240)
CODE_PAGE NUMBER
COMMENTS VARCHAR2(2000)
OWNER_ID NUMBER
GROUP_ID NUMBER
LAST_SAVED VARCHAR2(30)
CREATE_INFO NUMBER
OPB_OBJECT_ID NUMBER
OBJVERSION NUMBER
COMP_VERSION NUMBER
USER_PASSWORD2 VARCHAR2(2000)


SQL> select object_id, object_type,object_subtype, object_name, owner_id, create_info ,code_page,opb_object_id,owner_id, group_id , last_saved,
objversion, comp_version
from opb_cnx; 2 3

OBJECT_ID OBJECT_TYPE OBJECT_SUBTYPE OBJECT_NAME OWNER_ID CREATE_INFO CODE_PAGE OPB_OBJECT_ID OWNER_ID GROUP_ID LAST_SAVED OBJVERSION COMP_VERSION
---------- ----------- -------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ---------- ----------- ---------- ------------- ---------- ---------- ------------------------------ ---------- ------------
10 73 101 TUTORIAL_SOURCE 2252 -5.355E+27 -2.01E-100 64 2252 2 ? 0 1
11 73 101 TUTORIAL_TARGET 2252 -5.355E+27 -2.01E-100 64 2252 2 ? 0 1

Can i delete them from the db and recreate them ?

Thanks in Advance
Vishal