Oracle complains about long identifier on simple operations.

Submit to reddit

Soo,

I’m going head first into the oracle db world. I was trying to create an spfile from the pfile and of course it didn’t work:

1
2
3
4
5
SQL> CREATE spfile FROM pfile="/oracle/app/product/12.1.0/dbhome_1/dbs/initORCL.ora";
CREATE spfile FROM pfile="/oracle/app/product/12.1.0/dbhome_1/dbs/initORCL.ora"
*
ERROR AT line 1:
ORA-00972: identifier IS too LONG

 

The reason is simple enough, you have to use single quotes instead of double quotes. But it took me a while to find out this so here it is for all other beginners.

 

1
2
3
4
5
SQL> CREATE spfile FROM pfile='/oracle/app/product/12.1.0/dbhome_1/dbs/initORCL.ora';

FILE created.

SQL>