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
The mechanism of sync process may rename the target table to something else before renaming it back to the original name.
During the synchronization using "copy table", the sync client first truncates the target table, then it renames the target table to the name of the source table, if the source table and target table are different with respect to name and/or schema. It then imports the data from the source table to the renamed target table using Oracle Import. Once the import finishes, it renames the newly populated target table back to the original name of the target table. If an attempt is made to query the target table during the time it was renamed to the source table name, then you will see ORA-00942. But this is only a transient phenomenon and is not a cause for concern. Once the copy finishes its job, the newly sync'd target table would be visible. So when one finally issues a SELECT, for instance, it will return the rows from the target table.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy