Oracle Create spfile from memory

 

Oracle Create spfile from memory





create spfile from memory;
create spfile from memory
*
ERROR at line 1:
ORA-32002: cannot create SPFILE already being used by the instance  


Use below command 

spfile 
create spfile='/home/oracle/spfileanuj.ora' from memory;

File created.


pfile 
create pfile='/home/oracle/pfileanuj.ora' from memory;
File created.

ORA-12838: cannot read/modify an object after modifying it in parallel

 

ORA-12838: cannot read/modify an object after modifying it in parallel


INSERT /*+ APPEND */ INTO spm_test_tab
SELECT level,
       'Description for ' || level
FROM   dual
CONNECT BY level <= 10000;




SELECT description
FROM   spm_test_tab
WHERE  id = 99;
FROM   spm_test_tab
       *
ERROR at line 2:
ORA-12838: cannot read/modify an object after modifying it in parallel


==============================================================================================
Commit statement will fixed the error ORA-12838
==============================================================================================

SQL> select count(*) from spm_test_tab ;
select count(*) from spm_test_tab
       *
ERROR at line 1:
ORA-12838: cannot read/modify an object after modifying it in parallel


SQL> commit ;  <<<<<  !!!!! commit ...

Commit complete.



now working !!!!

SQL> select count(*) from spm_test_tab;

  COUNT(*)
----------
     10000