A number of scenarios exist in which tables and databases in a job continue to be copied after a table or database copy fails.
Utility Used | Objects Copied | Scenario | Result |
---|---|---|---|
ARC | Tables | Source user does not have DUMP access to a table | Table copy fails in the Archive phase. Job continues and all of the remaining tables in the job are copied to the target database. |
ARC | Tables | Target user does not have RESTORE access to a table | Table copy fails in the Copy phase. Job continues and all remaining tables in the job are copied to the target database. |
ARC | Tables | Any source table is being fastloaded or multiloaded | All tables are copied to the target database, but the status output for the loaded state table shows 0 rows for Archive, Copy, and Complete status. |
ARC | Tables | Any source table is being restored by another ARC process | All tables, including those in the restored state, are copied to the target database, but the status output for the restored state table shows 0 rows for Archive, Copy, and Complete status. |
ARC | Tables | Target user does not have CREATE TABLE access to one of the databases | ARC skips the tables from that database. All tables in a database where CREATE TABLE access is copied to the target database. |
ARC | Databases | Source user does not have DUMP access to one of the databases | ARC skips that database, but all databases where DUMP access is copied to the target database. |
ARC | Databases | Target user does not have RESTORE access to one of the databases | ARC skips that database, but all databases where RESTORE access is copied to the target database. |
ARC | Databases | Target user does not have CREATE TABLE access to one of the databases | ARC skips that database, but all databases where CREATE TABLE access is copied to the target database. |
TPTAPI | Tables | Table has an incorrect column name in its WHERE clause | Table copy fails. Job continues and the remaining tables are copied to the target database. |
TPTAPI | Tables | Source user does not have SELECT access to one of the tables | Table copy fails. Job continues and the remaining tables are copied to the target database. |