ALTER DATABASE DEFAULT TEMPORARY TABLESPACE

How to Resolve ORA-02231: missing or invalid option to ALTER DATABASE

by Ed Chen
December 22, 2022December 28, 2022

ORA-02231 ORA-02231 means that a keyword is missing from the position where it should be in ALTER DATABASE statement. Most likely, it's a syntax error.… Read More »

Alter Database Default Temporary Tablespace Examples

by Ed Chen
August 25, 2022August 18, 2023

To globally change the default temporary tablespace of a database, we take the following steps: Check Current Default Temporary Tablespace Make Sure the Target Tablespace… Read More »

JavaScript is not enabled. Please enable it and reload the page.