Database Utilities (MOSC)

MOSC Banner

How to resolve EXP-00091 due to NLS_LANG incompatibility?

edited Oct 8, 2009 3:58AM in Database Utilities (MOSC) 12 commentsAnswered ✓
 Hi,

   9iR2 Production DB on Sun OS 9 (NLS_LANG=WE8ISO8859P1)

                           |

                           | Export dumps with many EXP-00091 errors

                           |

   9iR2 client on XP (NLS_LANG=WE8MSWIN1252)

                           |

                           | Import dumps (Haven't done it yet.)

                           |

   11gR1 Production DB on Red Hat Linux 5.3 (NLS_LANG=WE8MSWIN1252)

Since I can't get the 9iR2 client working on the Linux box, I try to use the client on my laptop to export data.  I have no direct access to the 9iR2 production server, but only thru remote sqlplus connection.

Q1: Is there anyway to find out the env parameter NLS_LANG remotely on the 9iR2 production server?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center