ORA-00959

How to Resolve ORA-00959: tablespace does not exist

by Ed Chen
May 25, 2022April 12, 2022

ORA-00959 Tried to add a data file to a tablespace, but it failed with ORA-00959. SQL> alter tablespace example01 add datafile '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/example02.dbf' size 10m autoextend… Read More »

How to Resolve ORA-65144: ALTER SYSTEM DISABLE RESTRICTED SESSION is not permitted

by Ed Chen
April 11, 2022May 18, 2022

ORA-65144 Tried to remove restricted mode from a newly cloned PDB, but it failed with ORA-65144. SQL> show pdbs CON_ID CON_NAME … Read More »