Adding or changing an exception table
These steps are part of the larger task of checking data in table spaces.
When you complete the steps for adding or changing an exception table, return to
Checking data in table spaces.
If you choose, you can have any row in violation of referential or table
check constraints copied to an exception table. If any row violates
more than one constraint, it appears no more than once in the exception
table.
To add an exception table:
-
In the Add Exception Table window, for the source table from which rows are to be copied, type the table owner
name, or use the ellipses to search and select a valid table owner.
-
For the exception table into which error rows are to be copied, type the
table name, or use the ellipses to search and select a valid table name.
To change an exception table:
-
In the Change Exception Table window, for the source table from which rows are to be copied, type the table owner
name, or use the ellipses to search and select a valid table owner.
-
For the exception table into which error rows are to be copied, type the
table name, or use the ellipses to search and select a valid table name.
Return to main task