Return
-
Title
Is it necessary to create a separate temporary tablespace for the LiveReorg user? -
Description
Is it necessary to create a separate temporary tablespace for the LiveReorg user?
-
Resolution
No, it is not necessary as LiveReorg uses the 'LW_TABLESPACE' that you have nominated (during QSA installation) to hold temporary objects during a reorg.
You can run the following query to check which tablespace it is usingSQL> select value from quest_exec_parameter where name = 'LW_TABLESPACE';