Skip Headers

Oracle® Database Lite SQL Reference Release 10.3 Part Number E12092-02 |
Home | Book List | Contents | Index | Contact Us

Previous | Next
| View PDF

# B SQL Limitations For Oracle Database Lite

There are limitations to SQL that is different than the Oracle database, as follows:

Table B-1 Datatype Limits

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

Table B-4 Process/Runtime Limits

Item | Limit | Comments
--- | --- | ---
Shared Memory | 128 MB Maximum |
Cache | 64 4K blocks by default | Used for caching database pages