Oracle Database Discussions

In My Prod database some of the tablespaces assigned system as Temporary tablespace. I want to change the temporary tablespace for these schemas and the default temporary tablespace of the database.

Can I make this change while the users are accessing the database. Is there any impact If i make this change while the transactions are running.

Below is the change i want to do........

1. Change the users for SYSTEM to TEMP in the temporary tablespace by executing the following SQL
statements:

alter user SYSTEM temporary tablespace TEMP;
alter user SYS temporary tablespace TEMP;
alter user AD_MONITOR temporary tablespace TEMP;
alter use SI_INFORMTN_SCHEMA temporary tablespace TEMP;
alter user EM_MONITOR temporary tablespace TEMP;
alter user ORDPLUGINS temporary tablespace TEMP;
alter user TSMSYS temporary tablespace TEMP;
alter user XDB temporary tablespace TEMP;
alter user SCOTT temporary tablespace TEMP;
alter user DBSNMP temporary tablespace TEMP;
alter user DIP temporary tablespace TEMP;
alter user OUTLN temporary tablespace TEMP;
alter user ANONYMOUS temporary tablespace TEMP;
alter user ORDSYS temporary tablespace TEMP;
alter user MDDATA temporary tablespace TEMP;

2. Set the default temporary tablespace to TEMP by executing the following SQL statement:

alter DATABASE default temporary tablespace TEMP;