ORA-00942 encountered when querying a Target table known to be in replication.
SQL> select * from owner.target_tablename;
select * from owner.target_tablename
*
ERROR at line 1:
ORA-00942: table or view does not exist
This can occur if you query the Target table during the execution of a "copy table".
During a “copy table” synchronization, the process truncates the Target table, then temporarily renames it to match the Source table if their names or schemas differ.
Data is imported from the Source table using Oracle Import.
After completion, the Target table is restored to its original name.
Queries executed during the rename may return ORA-00942, which is expected and not an issue.
Once the process finishes, the updated Target table becomes available for normal queries.
