In this post, you’ll learn more about the Oracle ErrorORA-30659: too many locations specified for external table with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-30659: too many locations specified for external table
Reason for the Error ORA-30659: too many locations specified for external table
An attempt was made to create an External Organized table with more than the maximum allowable (32767) locations specified.
How to fix the Error ORA-30659: too many locations specified for external table ?
You can fix this error in Oracle by following the below steps
Don’t do that, use fewer location clauses. Either consider concatenating the input files, or, creating two external tables with the input files split between them.