Site icon IT Tutorial

ORA-02236: invalid file name

I got “ORA-02236: invalid file name ”  error in Oracle database.

 

ORA-02236: invalid file name

 

Details of error are as follows.

ORA-02236: invalid file name

Cause: A character string literal was not used in the filename list of a LOGFILE, DATAFILE, or RENAME clause.

Action: Use correct syntax.


 

 

invalid file name

This ORA-02236 error is related to the character string literal was not used in the filename list of a LOGFILE, DATAFILE, or RENAME clause.

Use correct syntax.

 

SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 3 size 4G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 3 size 4G
*
ERROR at line 1:
ORA-02236: invalid file name
 




SQL> alter database add standby logfile size 2G;
Database altered.

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

Exit mobile version