Database DataWarehousing (MOSC)

MOSC Banner

Maximum number of rows in an external table

edited Apr 22, 2012 11:50PM in Database DataWarehousing (MOSC) 1 commentAnswered

Hi - can anyone tell me what the maximum number of rows which can be accessed in an external table is, please? I see (from note 336186.1) that the maximum number of rows in a database table is unlimited, and that the maximum size of an external file is o/s dependent (in this case the o/s is Solaris). The reason for this question is that at the weekend we hit the SQL*Ldr limit of 4,294,967,295 (I believe this is a 'hard' limit which cannot be increased - is this true?) and, whilst we could split the SQL*Ldr file into 2 or more files I wonder whether we would be better advised to define the file as an external table, and read the rows into the database

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center