All geek questions in one place

Oracle 11g External Table Size Limit

Is there a limit for files that are defined as external tables in Oracle 11g? According to http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/limits002.htm , the last parameter External File Table is Maximum Size , it depends on the operating system.

Does this mean that external tables can be as large as the underlying OS or file system?

+4
source share
2 answers

Although I could not find a definitive answer, I feel that any file used for an external table can be as large as the OS. You can have mutliple files for each external table definition, so your external table can, at least theoretically, be very large, although performance here will be a limiting factor. Again, there seems to be no definitive answer to the number of files you can have to define an external table. Here's a link to 11g limits that exactly match the 10g page you posted.

+3
source

The limit on the number of files specified in the LOCATION clause is 32767. Each place is transferred to the access driver as ODCIArgDesc, then VARRAY ODCIArgDescList has a size of 32767 (do "describes ODCIArgDescList").

The size of external files is limited / determined by the OS system calls that access the files, and this depends on the OS port. However, most modern operating systems support 64-bit file sizes. Some operating systems may still be stuck in 32-bit files.

+1
source

Source: https://habr.com/ru/post/1344759/

More articles:


All Articles