Knowledge Base

Only use valid format mask,and do not repeat

ORA-01810: Format code appears twice

If you are accessing data over a database link you can get this error if the database version you’re connecting to does not know some of the NLS parameters of the database you’re connecting from.
eg. Oracle 7.1.6 does not know the date format RRRR, so if the database you’re connecting from has NLS_DATE_FORMAT set to ‘DD/MM/RRRR’ and you’re connecting to a 7.1.6 (anything lower than 7.2), this error will occur.

SQL> select * from v$version@713.world;

BANNER
----------------------------------------------------------------
Oracle7 Server Release 7.1.3.2.0 - Production Release
...

SQL> select * from global_name@713.world;

GLOBAL_NAME
--------------------------------------------------------------------------------
713.WORLD

SQL> alter session set NLS_DATE_FORMAT='DD/MM/RRRR';
ERROR:
ORA-01810: format code appears twice
ORA-02063: preceding line from 713.WORLD


Last error occurred immediate because the database link was still open.

Oracle Gold Partner DbMotive is an Oracle Gold Partner