ORA-00940

How to Resolve ORA-00940: invalid ALTER command

by Ed Chen
September 8, 2021March 25, 2022

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 »

Alter Temporary Tablespace Correctly

by Ed Chen
February 15, 2020February 12, 2023

Some statements about temporary tablespaces are NOT valid to perform. Create a Temporary Tablespace You can't create a temporary tablespace like a normal, permanent tablespace.… Read More »