When running copy table from a source on higher version of Oracle to a target on lower version of Oracle, copy status shows the following:
Job ID : 2
Host : server_name
Started : 09-DEC-08 20:03:49
Job Type : Copy
Status : Failed - Version of import running on target incompatible with version of export
ID Tablename Total Rows %Comp Status Status Time Total Time
------ ------------------------------------ ---------- ----- ---------- ----------- ----------
1 owner.table_name 5041752 Failed N/A 0:02
The copy log on source shows the following entries:
Tue Dec 09/20:03:52.398:: Inserting SYNC Marker Tue Dec 09/20:03:52.410:: ERROR: Oracle versions are incompatible at sync/svr/sync_svr_messager.cpp:749
The Oracle version on source is higher than the one on the target.
The copy table only works for similar Oracle versions on source and target or a lower Oracle version on source and a higher Oracle version on target. In this case, the Oracle version on source is higher than the Oracle version on target. This will cause the copy to fail.
The Reference Guide has this requirement listed as follows:
What the copy/append command does not support
The copy/append command does not support:
Copying from a higher version of Oracle to a lower version of Oracle.
.
.
