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 »How to Resolve ORA-02231: missing or invalid option to ALTER DATABASE
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 »Alter Database Default Temporary Tablespace Examples
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 »Alter Database Default Tablespace Examples
ORA-00940 ORA-00940 means that you use an invalid object type for ALTER operation, usually it's because you misspelled the object type name. First of all,… Read More »How to Resolve ORA-00940: invalid ALTER command
Offline a Temporary Tablespace Theoretically, you can't take the whole temporary tablespaces offline. SQL> alter tablespace temp offline; alter tablespace temp offline * ERROR at… Read More »How to Alter Temporary Tablespace Offline
According to SQL syntax of Oracle database, you can't resize the data files by using ALTER TABLESPACE except the tablespace was created as BIGFILE, but… Read More »You Cannot Resize a DataFile in "ALTER TABLESPACE" Except ...