There are limitations to SQL that is different than the Oracle database, as follows:
Datatypes | Limit | Comments |
---|---|---|
BFILE |
Maximum size: 2 GB Maximum size of the directory or file names: no database imposed limit |
All BFILE objects are stored as LOB |
BLOB |
Maximum size: 2 GB |
|
CHAR |
Maximum size: 4096 bytes |
|
CLOB |
Maximum size: 2 GB |
|
Literals |
No limit |
|
LONG |
Maximum size: 2 GB |
A table can have any number of long columns |
NUMBER |
Operating system limit |
NUMBER is converted to a double precision number on the native platform |
NUMBER (p, s) |
999 ... (38 9's) x 10 ^ 125 maximum -999... (38 9's) x 10 ^125 minimum |
Maximum precision of 38 decimal digits |
VARCHAR |
Maximum size: 4096 bytes |
|
VARCHAR2 |
Maximum size: 4096 bytes |
Table B-2 Physical Database Limits
Item | Limit | Comments |
---|---|---|
Database Block Size |
4096 bytes |
Fixed size |
Database File |
1 database file for each catalog |
An application can open any number of catalogs. |
Database File Size |
4 GB |
Affected by the operating system. Maximum file size allowed by the operating system. |
Max Object or Row Length |
4040 |
When an object (row) exceeds this length, it is converted into a binary long object. So, UNION will not work on this table. |
DSN Name |
31 bytes (31 US chars) |
Limit is 31 bytes |
Database Path Name |
129 bytes |
_MAX_PATH -5, which is 255 on Win32 |
Database filename |
129 bytes |
_MAX_PATH -8, which is 252 on Win32. |
Table B-3 Logical Database Limits
Item | Limit | Comments |
---|---|---|
Indexes |
Maximum for each table |
unlimited |
Columns |
table |
1000 |
index |
32 columns maximum |
|
Constraints |
Maximum for each column |
unlimited |
Nested queries |
Maximum number |
unlimited |
Rows |
Maximum number for the table |
no limit |
SQL statement length |
Maximum length of statements |
unlimited, particular tools may impose lower limits |