Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
impdp and expdp report encoding warnings in the form of:
export done in A character set and B character set
import done in C set and C character set
Why do both warnings name two character sets? What to they refer to? It seems to be always two, so it's not just a list.
Databases have 2 character sets: 1 default character set (used by CHAR, VARCHAR2, CLOB) and 1 national character set (used by NCHAR, NVARCHAR2, NCLOB).
For example: AL32UTF8 + AL16UTF16
You can query them from NLS_DATABASE_PARAMETERS.
