ALTER TABLE

How to Resolve ORA-01466: unable to read data - table definition has changed

by Ed Chen
March 16, 2023March 21, 2023

ORA-01466 Tried to perform a flashback query, but it failed with ORA-01466. SQL> select count(*) cnt from t1 as of timestamp to_timestamp('2023-02-19 22:15:00', 'yyyy-mm-dd hh24:mi:ss');… Read More »

How to Resolve ORA-01542: tablespace is offline, cannot allocate space in it

by Ed Chen
July 29, 2022September 3, 2022

ORA-01542 Tried to move a table to another tablespace, but we got ORA-01542. SQL> alter table employees move tablespace users online; alter table employees move… Read More »

How to Resolve ORA-02216: tablespace name expected

by Ed Chen
May 20, 2022February 12, 2023

ORA-02216 ORA-02216 means that SQL parser finds no identifier at the position where expects a tablespace name. Basically, it's a syntax error. To correct it,… Read More »

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 TABLE Syntax for All Releases of Oracle Database

by Ed Chen
July 1, 2020December 9, 2022

Here is the list of ALTER TABLE Syntax for All Releases of Oracle Database. You may press Ctrl + d to bookmark this page. ALTER… Read More »

How to Resolve ORA-00942: table or view does not exist

by Ed Chen
March 23, 2019February 20, 2023
4 Comments

ORA-00942 ORA-00942 means that SQL engine found no table or view in your usable scope. In other words, table or view does not exist. The… Read More »