Updating Data in SDO Tables

Modification of the contents of a SDO cached table is not allowed. The only way to modify the contents of a SDO cached table is to define it as being non SDO by setting CacheSize to 0 for that data object, recycling the application server, modifying table contents, resetting CacheSize back to its original setting and again recycling the application server. Since this procedure involves multiple application server recycles it is recommended that you simulate and adequately test property changes in a test environment before applying them in the production environment.