Oracle has made several enhancements in LOB storage so as to provide better performance and utilizing less storage. As the name suggest, Securfile LOB secure the LOB data.
Click here to get complete Overview of Securfile LOB
Thursday, December 27, 2007
Oracle 11g - Recover from loss of SPFILE
Prior to 11g, we have to explicitly specify SCOPE=SPFILE or BOTH to add initialization parameters changes in the SPFILE. With 11g, Oracle has provided some good enhancement so as manage the PFILE / SPFILE as shown below
1. CREATE pfile FROM MEMORY
2. CREATE Spfile FROM MEMORY
3. Check the location of the Paramter PFILE or SPFILE used to start the Database
CLICK here to get full article about SPFILE recovery
1. CREATE pfile FROM MEMORY
2. CREATE Spfile FROM MEMORY
3. Check the location of the Paramter PFILE or SPFILE used to start the Database
CLICK here to get full article about SPFILE recovery
Subscribe to:
Posts (Atom)
