Voltar
-
Título
Tables with both identity and without identity and Preserve Data Method set to 'Use Temporary -
Descrição
When altering a SMS tablespace to add new data files, the tablespace has to be recreated. If the tablespace contains tables with both identity and without identity and Preserve Data Method set to "Use Temporary tables" and these tables are included in the steps of temporary tables, then these tables will fail to create.
These tables should be dropped and then recreated since their data is preserved using utilities and no temporary tables are needed.
Login necessário
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.