Return
-
Title
Querying a replicating table on target which is currently involved in a sync process by copy tabl -
Description
One starts sync process by issuing "copy <owner.source_tablename> to <owner.target_tablename>" and while the copy is still running, queries the target table by issuing a SELECT. However, the command returns ORA-00942 as below:
SQL> select * from owner.target_tablename;
select * from owner.target_tablename
*
ERROR at line 1:
ORA-00942: table or view does not exist
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.