How can I remove (reset) pdb parameters from its spfile
Hi
Oracle Linux 7
Oracle 19.6 RAC (2-node)
I would like to remove these 2 parameter, that have SID='*'.
SQL> select db_uniq_name, pdb_uid, name, value$, sid from pdb_spfile$ where name like 'undo%' order by pdb_uid;DB_UNIQ_NA PDB_UID NAME VALUE$ SID---------- ---------- --------------- --------------- --------------------------------------------------------------------------------* 1547780192 undo_tablespace 'UNDOTBS2' cdb2* 1547780192 undo_tablespace 'UNDOTBS1' cdb1* 1547780192 undo_tablespace '' ** 1565462022 undo_tablespace 'UNDOTBS1' cdb1* 1565462022 undo_tablespace '' ** 1565462022 undo_tablespace 'UNDOTBS2' cdb2* 1746351333 undo_tablespace 'UNDOTBS2' cdb2* 1746351333 undo_tablespace 'UNDOTBS1' cdb1
8 rows selected.
I have tried:
SQL> alter system reset undo_tablespace container=current sid='*' scope=spfile;alter system reset undo_tablespace container=current sid='*' scope=spfile *ERROR at line 1:ORA-00933: SQL command not properly ended
0