Original Export / Import

How to Set Export Import Character Set

Posted on
Garbled Text Garbled data was found after importing a normal dump file. After doing some inspections, I found there’s NLS_LANG environment variable for user oracle in the source database server, but no NLS_LANG in the target server. Default Character Set of Sessions Since there’s no NLS_LANG to set NLS parameters at session-level, the import session […]
Data Pump

How to expdp AS SYSDBA

Posted on
expdp AS SYSDBA Normally, we use system to migrate data from one to another, who has pretty enough privileges for all kinds of manipulation at content-level. Whereas SYSDBA is the highest privilege which usually does maintenance and critical jobs like STARTUP or SHUTDOWN. Whenever we are using to connect to the database with SYSDBA privilege, […]