Oracle DBA Question: Download Oracle DBA 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.
| Previous Question | Next 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? |