Voltar
-
Título
Error "Value does not match the type of column" when trying to import into a temporal table that has hidden system generated columns. -
Descrição
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,
Login necessário
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.