The issue with default temporary tablespace during the upgrade process from Oracle version 12.2 to 19c is that the default temporary tablespace changes from SYSTEM to a new tablespace called TEMP. If the upgrade process fails to create the TEMP tablespace or assign it as the new default temporary tablespace, it can cause issues with various database operations, such as creating temporary tables and performing sorts. It is recommended to manually create the TEMP tablespace and set it as the default temporary tablespace before starting the upgrade process.
Asked: 2023-06-03 07:30:05 +0000
Seen: 9 times
Last updated: Jun 03 '23