Reading a table TEMP_TAB from an oracle schema and writing it into TEMP_TAB_STG table in another oracle schema. These two schemas are on different servers. Following is the job design. Truncate TEMP_TAB_STG table | on sub job ok | Read TEMP_TAB table ---> tMap---> Write into TEMP_TAB_STG(Action on table: Default, Action on data: Insert) I'm getting following error while executing the job as a batch file. But, if I retry 3 to 4 times, then t is completed successfully. ORA-08103: object no longer exists There are no indexes or partitions on the source and target tables. No database maintenance activities happen on the database during the execution of the job. Please help me on how to solve this problem.
