Recently, I was approached by one of my customer’s dba team. They were migrating data from their production database running on Oracle DBMS to a Tera data database system. One column of type VARCHAR2 from the source table had multiple end of line and carriage return characters because that column was related to a comment field on the front end form. Tera data was not able to handle these special characters and was failing the import process.

Yes, if table has columns defined for future usage and currently storing null values and No, if columns have data in them.