Ed Chen Logic

How to Resolve SP2-0547: size option out of range

by Ed Chen
May 27, 2022May 28, 2022

SP2-0547 Saw error SP2-0547 when we tried to set the buffer size of server output in SQL*Plus. SQL> set serveroutput on size 1000; SP2-0547: size… Read More »

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-02140: invalid tablespace name

by Ed Chen
May 23, 2022April 8, 2022

ORA-02140 There're 2 types of ORA-02140 when we tried to add a data file to a tablespace. 1. SQL> alter tablespace user add datafile '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/users02.dbf'… Read More »

How to Resolve ORA-02216: tablespace name expected

by Ed Chen
May 20, 2022May 23, 2022

ORA-02216 ORA-02216 means that SQL parser finds no identifier at the position where expects a tablespace name. Basically, it's a syntax error. To correct it,… Read More »

How to Resolve ORA-02180: invalid option for CREATE TABLESPACE

by Ed Chen
May 19, 2022May 22, 2022

ORA-02180 There're 2 basic patterns of error ORA-02180 in this post: Missing Tablespace Name Missing Keyword A. Missing Tablespace Name If we didn't specifiy the… Read More »

How to Resolve ORA-27040: file create error, unable to create file

by Ed Chen
May 18, 2022May 20, 2022

ORA-27040 Tried to add a data file to a tablespace, but it failed with ORA-01119 and ORA-27040. SQL> ALTER TABLESPACE EXAMPLE ADD DATAFILE '/u01/app/oracle/oradata/ORCLCDB/ORCLPDBX/example02.dbf' SIZE… Read More »

How to Resolve ORA-01507: database not mounted

by Ed Chen
May 16, 2022May 24, 2022

ORA-01507 ORA-01507 means that the command you want to execute cannot be done at NOMOUNT state, you should try to mount the database from NOMOUNT… Read More »

How to Flip Session Browser Layout

by Ed Chen
May 13, 2022March 28, 2022

After your Toad for Oracle installed in a new computer, you may see a strange layout in Session Browser like mine. It's a vertical layout… Read More »

How to Resolve ORA-28650: Primary index on an IOT cannot be rebuilt

by Ed Chen
May 11, 2022May 27, 2022

ORA-28650 Tried to move and rebuild an index to another tablespace, but it failed with ORA-28650. SQL> alter index hr.country_c_id_pk rebuild tablespace users online; alter… Read More »

RMAN Backup Records are Lost Regularly

by Ed Chen
May 9, 2022May 10, 2022

I found something unusual about RMAN backup records. 1. Obsolete Not Deleted Some backup files older than 3 months are definitely obsolete according to redundancy… Read More »