impdp with different table structures
We have datapump export files that we load regularly. The databases that export the files are supposed to add an additional column but not all have done so.
We have added the new column, which is at the end of the tables, to the import tables. The databases are on 2 different OS. On Windows 10.2.0.4.0 64bit, it imports the tables lacking the additional column with no error. But on a Solaris, also 10.2.0.4.0 64bit, it gives an error:
ORA-39786: Number of columns does not match between export and import databases
Is this just a different behavior built into the 2 versions? Is the Solaris doing what it's supposed to do or is there a way around it?