Using the Command Line to Export and Import an Oracle Dump File

When the Oracle user name is in a Unicode language (for example, Chinese or Japanese), you cannot use the Oracle Data dialog box to manage the data transfer. In this case, use the following procedure instead.

Note: The instructions assume that you are using the Windows 7 operating system.

The procedure is a two-step process:

• Change the active code page for the command prompt and execute the Oracle Export command.
• Change the active code page for the command prompt and import the Oracle Dump file.

To export the data from Oracle using the command line

1. Change the active code page of the command prompt.

   The command prompt you use to execute the Oracle Export and Import commands is not a Unicode-enabled tool.

   • In Windows 7, go to Control Panel > Clock, Language And Region > Change Keyboards Or Other Input Methods > Administrative > Language For Non-Unicode Programs.
   • Change the current language to your requirements.

     For example, to export a Chinese User Name like “中文用户名,” change the language to “Chinese (Simplified, PRC)."

   • Restart the operating system.
2. After the restart, open a command prompt and execute the command CHCP to see the active code page for your command prompt.
3. Enter the following command to set the National Language Support environment variable correctly:

   Set NLS_LANG= Language_Territory.Characterset

   For example, for simplified Chinese, enter the following:

   Set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

4. Execute the Oracle Export command.

To import the Oracle dump file

1. Change the active code page of the command prompt.

   The command prompt you use to execute the Oracle Export and Import commands is not a Unicode-enabled tool.

   • In Windows 7, go to Control Panel > Clock, Language And Region > Change Keyboards Or Other Input Methods > Administrative > Language For Non-Unicode Programs.
   • Change the current language to your requirements.

     For example, to export a Chinese User Name like “中文用户名,” change the language to “Chinese (Simplified, PRC)."

   • Restart the operating system.
2. After the restart, open a command prompt and execute the command CHCP to see the active code page for your command prompt.
3. Enter the following command to set the National Language Support environment variable correctly:

   Set NLS_LANG= Language_Territory.Characterset

   For example, for simplified Chinese, enter the following:

   Set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

4. Execute the Oracle Import command.