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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center