How to Resolve ORA-00946: missing TO keyword

ORA-00946

Tried to rename a file of database, but it failed with ORA-00946.

SQL> alter database rename file '/oradata/ORCLCDB/ORCLPDB/example01.dbf' '/oradata/TESTCDB/ORCLPDB/example01.dbf';
alter database rename file '/oradata/ORCLCDB/ORCLPDB/example01.dbf' '/oradata/TESTCDB/ORCLPDB/example01.dbf'
                                                                     *
ERROR at line 1:
ORA-00946: missing TO keyword

ORA-00946 means that the keyword TO is missing from the statement you issued, which causes a syntax error.

Solution

To solve ORA-00946, we should follow the error message.

SQL> alter database rename file '/oradata/ORCLCDB/ORCLPDB/example01.dbf' to '/oradata/TESTCDB/ORCLPDB/example01.dbf';

Database altered.

We made it.