Rejected Data as Table
For creating Rejected table, we are using a copy statement such as below (v7.2.3-2)
copy reject_1(test) from stdin rejected data as table schema.reject_table;
\.
This is used to just to get the rejected table created both in Prod and DR. However, this on-the-fly DDL seems to be different in Prod than in DR.
rejected_data column has shown up as 'varchar' in Prod but as 'long varchar' in DR. Both are created at the same time. I did not see any parameter that we can set at system level that could cause this difference.
Any thoughts?
0