The error table is associated with the foreign table specified in the CREATE ERROR TABLE statement, and only contains rows that came from queries against the foreign table. The following the syntax for creating an error table on OFS.
CREATE ERROR TABLE [ error_table_name_specification ], [STORAGE = TD_OFSSTORAGE] FOR data_table_name_specification [;]
The error table syntax for OFS does not have NO RLS element.
- error_table_name_specification
[ database_name. | user_name.] error_table_name
- data_table_name_specification
[ database_name. | user_name. ] data_table_name