User 818520b6b8
19-04-2005 09:21:21
Hi all,
I altered the table where structures ar stored and changed the column data type for CD_STRUCTURE from LONG RAW to BLOB, issuing an ALTER TABLE statement.
Afterwards I rebuilded all the indexes on this table.
And, as Oracle documentation says, everything is still working fine.
Is this supported?
I'd like you to think in using BLOBs for structures in next release of JChem as the change is not so important.
Please refer to Oracle Documentation:
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adfnstyp.htm#435240
Migrating LONG Datatypes to LOB Datatypes
The LONG datatype can store variable-length character data containing up to two gigabytes of information, depending upon available memory. LONG columns have many of the characteristics of VARCHAR2 columns. You can use them in SELECT lists, SET clauses of UPDATE statements, and VALUES clauses of INSERT statements.
Oracle Corporation recommends using the LONG datatype only for backward compatibility with old applications. For new applications, you should use the CLOB and NCLOB datatypes for large amounts of character data. Typically, you can change LONG data to LOBs in your tables without changing existing applications. SQL, PL/SQL, and OCI interfaces for LONG data can all work on LOB data as well.
Thanks a lot.
I altered the table where structures ar stored and changed the column data type for CD_STRUCTURE from LONG RAW to BLOB, issuing an ALTER TABLE statement.
Afterwards I rebuilded all the indexes on this table.
And, as Oracle documentation says, everything is still working fine.
Is this supported?
I'd like you to think in using BLOBs for structures in next release of JChem as the change is not so important.
Please refer to Oracle Documentation:
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adfnstyp.htm#435240
Migrating LONG Datatypes to LOB Datatypes
The LONG datatype can store variable-length character data containing up to two gigabytes of information, depending upon available memory. LONG columns have many of the characteristics of VARCHAR2 columns. You can use them in SELECT lists, SET clauses of UPDATE statements, and VALUES clauses of INSERT statements.
Oracle Corporation recommends using the LONG datatype only for backward compatibility with old applications. For new applications, you should use the CLOB and NCLOB datatypes for large amounts of character data. Typically, you can change LONG data to LOBs in your tables without changing existing applications. SQL, PL/SQL, and OCI interfaces for LONG data can all work on LOB data as well.
Thanks a lot.