Skip Headers
Oracle® Database Lite SQL Reference
Release 10.3

Part Number E12092-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
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