ALTER DATABASE DEFAULT 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 Tablespace Examples

by Ed Chen
August 24, 2022September 12, 2022

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

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