Return
-
Title
Error "Value does not match the type of column" when trying to import into a temporal table that has hidden system generated columns. -
Description
Using Toad Import Wizard to load data into a temporal table that has hidden system generated columns. Even after opting to skip these columns in the wizard, the following error occurs."Value does not match the type of column. Do you want to cancel?"The 3 columns in question are defined in the table as follows:SYSTEM_TS_START TIMESTAMP(12) NOT NULL IMPLICITLY HIDDEN GENERATED ALWAYS AS ROW BEGIN,SYSTEM_TS_END TIMESTAMP(12) NOT NULL IMPLICITLY HIDDEN GENERATED ALWAYS AS ROW END,SYSTEM_TS_TRANS_ID TIMESTAMP(12) IMPLICITLY HIDDEN GENERATED ALWAYS AS TRANSACTION START ID,
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.