Chapter 7. Using SecureFile LOBs

Today, the application development has taken a new turn to catch up with the growing business. The application environments employ some of the best strategies to accommodate the varied nature of data. Surveys have revealed an astonishing estimation that the nonstructured data grows annually by 65 percent in a typical enterprise data-based application. This pace is accredited to the growing content digitization, boost up rich user experience, web based structures, and physical file storage requirements.

In the previous chapter, we learned the traditional storage of large objects in Oracle. Since its release in Oracle 8i, they have worked well and served at par with the systems' requirements until Oracle 10g. The earlier LOB storage philosophy was based on certain assumptions which by now, were transformed into limitations. These assumptions were as follows:

• Size of the large object was expected to be in MBs

• Large objects would be less transactional

• No Encryption...