My Oracle Support Banner

EXP-15 EXP-1 on Table EXPORT (Doc ID 99120.1)

Last updated on DECEMBER 14, 2023

Applies to:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 8.0.5.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

 During export you receive:


The offending column is of type VARCHAR2 and there are no more errors.

You've checked the following:

+ There is enough space on the device you are going to put .dmp file on.
+ ANALYZE TABLE shows no errors.
+ Changing the size of buffer parameter does not help
+ Using dbverify against datafiles that contain table data gives no errors.
+ SELECT * FROM this table gives no errors.
+ CREATE TABLE <TABLE_NAME2> AS SELECT * FROM <TABLE_NAME> - no errors
+ EXPORT of <TABLE_NAME2> due to the same EXP-15 and EXP-1 complaining about the same row and column which is VARCHAR2.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.