Is it necessary to create a separate temporary tablespace for the LiveReorg user? (77355)

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

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 using

SQL> select value from quest_exec_parameter where name = 'LW_TABLESPACE';

Feedback submitted.

Was this article helpful?

[Select Rating]

Title