Limitations and Restrictions When you insert values into remote tables and not all values for all columns are specified, you must identify the columns to which the specified values are to be inserted.