How to fix the Oracle error EXP-00077: multiple output files specified for unbounded export file?

In this post, you’ll learn more about the Oracle ErrorEXP-00077: multiple output files specified for unbounded export file with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

EXP-00077: multiple output files specified for unbounded export file

Reason for the Error EXP-00077: multiple output files specified for unbounded export file

You specified multiple file names when doing an export and you also specified a value of 0 for the FILESIZE parameter. Note that 0 is the value used if FILESIZE is not specified on the command line. Since a value of 0 for FILESIZE means that only one file will be written and there is no size limit for that file, the other files you specified in the FILE parameter can never be used.

How to fix the Error EXP-00077: multiple output files specified for unbounded export file ?

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

If you intended to write multiple files, respecify the command but use the FILESIZE to specify the maximum number of bytes that EXPORT should write to each file. If you intended to write only one file with no limits on it’s size, reissue the EXPORT command but specify only one file name for the FILE parameter.