Oracle Solution for Error ora-30659

ORA-30659: too many locations specified for external table

What triggered the Error:

An attempt was made to create an External Organized table with more than the maximum allowable (32767) locations specified.

What should we do to fix it:

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.