Oracle DBA Question:
Download Questions PDF

When using Oracle export/import what character set concerns might come up? How do you handle them?

Answer:

Be sure to set NLS_LANG for example to "AMERCIAN_AMERICA.WE8ISO8859P1". If your source database is US7ASCII, beware of 8-bit characters. Also be wary of multi-byte characters sets as those may require extra attention. Also watch export/import for messages about any "character set conversions" which may occur.

Download Oracle DBA Interview Questions And Answers PDF

Previous QuestionNext Question
How do you use automatic PGA memory management with Oracle 9i and above?System tablespace cant be exported from one database and imported into another why?