I'm trying to export my Oracle 8i (184.108.40.206.0) database using Oracle 10g (10.2.0.4.0) 32-bit. When I execute the EXP command on the 10g server, I receive the following error:
EXP-00056: ORACLE error 6550 encountered
ORA-06550: line 1, column 41:
PLS-00302: component 'SET_NLS_NUMERIC_CHAR' must be declared
ORA-06550: line 1, column 15:
PL/SQL: Statement ignored
EXP-00000: Export terminated unsuccessfully
My Oracle 8i database is running on Windows 2000 Server (32-bit), and Oracle 10g database is running on Windows Server 2008 (32-bit). Any suggestions on where/how to set the SET_NLS_NUMERIC_CHAR component?