Showing posts with label ORA-30659: too many locations specified for external table. Show all posts
Showing posts with label ORA-30659: too many locations specified for external table. Show all posts

Wednesday, 23 May 2012

ORA-30659: too many locations specified for external table

ORA-30659: too many locations specified for external table

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

Action: 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.