Exforsys

H I D E

Home arrow Technical Training arrow Oracle 11g Tutorial

Table of Contents

 Oracle 11g SecureFiles
 Oracle 11g SecureFiles - Page 2
 Oracle 11g SecureFiles - Page 3
 Oracle 11g SecureFiles - Page 4

Oracle 11g SecureFiles Page - 4

Page 4 of 4
Author: Saurabh Gupta     Published on: 4th Sep 2011

Oracle 11g SecureFiles

Case 5: DB_SECUREFILE = IGNORE

This mode is very similar to the lastly discussed NEVER mode. As per the action, it also prevents the creation of SecureFiles in the system. In addition to the ‘NEVER’ like action, it also ignores the LOB storage clause, if specified. The same would have been raised an exception in NEVER mode.

Sample Code
  1. ----Set the DB_SECUREFILE parameter as ALWAYS----
  2. SQL> ALTER SYSTEM SET DB_SECUREFILE=IGNORE;
  3.  
  4. System altered.
  5.  
  6. ----Create table with SecureFile column on ASSM tablespace----
  7. SQL> CREATE TABLE IGNORE_SECUREFILE_1
  8.   2  (DOC BLOB)
  9.   3  LOB(DOC) STORE AS SECUREFILE
  10.   4  TABLESPACE USERS
  11.   5  /
  12.  
  13. TABLE created.
  14.  
  15. ----Create table with SecureFile column on non ASSM tablespace----
  16. SQL> CREATE TABLE IGNORE_SECUREFILE_2
  17.   2  (DOC BLOB)
  18.   3  LOB(DOC) STORE AS SECUREFILE
  19.   4  TABLESPACE SYSTEM
  20.   5  /
  21.  
  22. TABLE created.
  23.  
  24. ----Create table with BasicFile column on ASSM tablespace----
  25. SQL> CREATE TABLE IGNORE_BASICFILE_1
  26.   2  (DOC BLOB)
  27.   3  LOB(DOC) STORE AS BASICFILE
  28.   4  TABLESPACE USERS
  29.   5  /
  30.  
  31. TABLE created.
  32.  
  33. ----Create table with BasicFile column on non ASSM tablespace----
  34. SQL> CREATE TABLE IGNORE_BASICFILE_2
  35.   2  (DOC BLOB)
  36.   3  LOB(DOC) STORE AS BASICFILE
  37.   4  TABLESPACE SYSTEM
  38.   5  /
  39.  
  40. TABLE created.
Copyright exforsys.com


USER_LOBS shows the BasicFile behavior of all the above LOB columns.

Ads

Conclusion

Oracle 11g new features have already set the wavelength of PL/SQL application development in industry. With refreshing and emerging performance and storage philosophies, Oracle 11g has surely brought upgrades and exploration amongst database professionals.

I hope the tutorial has enough information to understand and demonstrate the functioning of Oracle SecureFiles. As I said, the access layer principle still remains the same; the readers must try their hands out on SecureFile access and read/write operations.

Read Next: Oracle VPD implementation


 
This tutorial is part of a Oracle 11g Tutorial tutorial series. Read it from the beginning and learn yourself.

Oracle 11g Tutorial

  1. Oracle 11g Result Cache
  2. Compound Triggers in Oracle 11g
  3. Oracle 11g Invisible Index
  4. Oracle 11g Virtual Columns
  5. Oracle 11g Collections
  6. Oracle Functions and Procedures
  7. Oracle 11g Exception Handling
  8. Oracle 11g Read Only Tables
  9. Oracle 11g Subprogram Overloading
  10. Conditional compilation in Oracle PL/SQL
  11. Oracle Pragma
  12. UTL_FILE
  13. Manage Oracle dependencies
  14. Oracle 11g SecureFiles
  15. Oracle VPD implementation
  16. PL/Scope and PL/SQL Hierarchical Profiler
  17. Oracle Partitioning Overview
  18. Oracle Analytic Enhancements
  19. Oracle XML Storage
 

Comments

 

Ads

Exforsys Connect

Ads

Exforsys e-Newsletter

ebook