ORA-30659: too many locations specified for external table



ORA-30659: too many locations specified for external table..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01924: role 'string' not granted or does not exist

1 Answers  


ORA-15021: parameter "string" is not valid in string instance

1 Answers  


TNS-00293: Trace File Name : string

1 Answers  


DRG-11108: invalid filename specified: string

1 Answers  


ORA-07804: slpdtb: number too large for supplied buffer

1 Answers  






DRG-13012: language column must be a char, varchar, or varchar2 type

1 Answers  


ORA-12726: unmatched bracket in regular expression

1 Answers  


PLS-00214: BEGIN...END block nesting is too deep

1 Answers  


ORA-02170: FREELIST GROUPS storage option not allowed

1 Answers  


imp-00038: could not convert to environment character set's handle error occurs while importing oracle 10g data into oracle 9i database.

1 Answers  


ORA-38304: missing or invalid user name

1 Answers  


ORA-32774: more than one file was specified for bigfile tablespace string

1 Answers  


Categories