How to fix the Oracle error IMP-00073: FILE locator “string” “string” is truncated to “string” “string” in server character set?

In this post, you’ll learn more about the Oracle ErrorIMP-00073: FILE locator “string” “string” is truncated to “string” “string” in server character set with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

IMP-00073: FILE locator “string” “string” is truncated to “string” “string” in server character set

Reason for the Error IMP-00073: FILE locator “string” “string” is truncated to “string” “string” in server character set

The conversion of the specified directory and name strings for a file attribute or column from the export server’s character set into the import server’s character set exceeded the maximum string lengths allowed within FILE descriptors. The strings will be truncated to the maximum supported lengths.

How to fix the Error IMP-00073: FILE locator “string” “string” is truncated to “string” “string” in server character set ?

You can fix this error in Oracle by following the below steps

Rename the directory aliases and external filenames to match the truncated names in the specified FILE column or attribute.