|Oracle9i Application Developer's Guide - Large Objects (LOBs)
Release 1 (9.0.1)
Part Number A88879-01
Managing LOBs , 2 of 12
A limited number of
BFILEs can be open simultaneously per session. The initialization parameter,
SESSION_MAX_OPEN_FILES defines an upper limit on the number of simultaneously open files in a session.
The default value for this parameter is 10. That is, you can open a maximum of 10 files at the same time per session if the default value is utilized. If you want to alter this limit, the database administrator can change the value of this parameter in the
init.ora file. For example:
If the number of unclosed files reaches the
SESSION_MAX_OPEN_FILES value then you will not be able to open any more files in the session. To close all open files, use the
SQL Data Manipulation Language (DML) includes basic operations, such as,
DELETE -- that let you make changes to the entire value of internal
LOBs within Oracle RDBMS.
For use case examples refer to the following sections in Chapter 10, "Internal Persistent LOBs":
It is possible to change the default storage for a LOB after the table has been created.
To move the CLOB column from tablespace A to tablespace B, in Oracle8 release 126.96.36.199, requires the following statement:
However, this returns the following error message:
ORA-02210: no options specified for ALTER TABLE