Tablespace Creation and Reassignment using SQL PLUS (Oracle)

It has been determined that user "SCOTT" should use a new temporary tablespace called TEMP2 size equivalent to TEMP tablespace (refer to Notes below for determining the size of TEMP). Create a script that performs the following

1. Create one Bigfile tablespace for TEMP2. size equal to the size of TEMP
2. Change the default temporary tablespace for "SCOTT" to TEMP2

Notes:

• The "DESCRIBE" command can be used to determine the fields in a table.
• Verify the temporary table space for user "SCOTT" by performing query on "user_users" table.
• Determine details of the temporary tablespace by performing query on "user_tablespaces".
• The CREATE TABLESPACE command is used to create a temporary big-file tablespace. Details of the command can be found in the "SQL Language Reference" documentation,
• The "ALTER USER" command can be used to change the temporary tablespace. Details of the command can be found in the "SQL Language Reference" documentation.