A file wants to be imported in an Oracle table.
The Update function is selected in the Import Table Data wizard.
The preview data shows all the data of the file, but after the import completes only some data is imported in the table.
Is there a way to see the records not being inserted/updated by Toad when using the Import table wizard?
Is there a way to import the non-existing data and update the existing one?
WORKAROUND:
There is no way to get the list of records not updated/inserted in Toad. The wizard will give only a summary of the process.
The Update function in the Import Table Data wizard will apply the changes to the existing values in the database table depending on the primary key.
If new data wants to be imported and existing data wants to be updated, the Merge function needs to be selected.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center