EXP-2 When Exporting From 10g With 9i Export Utility (Doc ID 469784.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 9.2.0.8
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.3
This problem can occur on any platform.

Symptoms

You want to export a 10gR2 database import the dump into 9iR2. For this reason you use the exp utility version 9iR2 and this ends with errors:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 -
64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring
Engine options
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully

The created export dump contains only the header that ends after DBTIMEZONE=UTC is received from server.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms