Ed Chen Logic

How to Resolve ORA-14808: table does not support ONLINE MOVE TABLE

by Ed Chen
December 6, 2021November 16, 2021

ORA-14808 Saw error ORA-14808 when we tried to move a Large Object (LOB) column to another tablespace online. SQL> alter table PM.PRINT_MEDIA move online lob(AD_PHOTO)… Read More »

How Oracle Move LOB Column

by Ed Chen
December 6, 2021December 5, 2021

Whenever tablespace is crowded, the first thought in my mind is to move INDEX to another tablespace, because it's very flexible to rebuild an index… Read More »

How Oracle Move Index

by Ed Chen
December 3, 2021November 10, 2021

Move Index To move an index is to rebuild a whole index either in the original tablespace or another tablespace with some options like ONLINE… Read More »

How to Resolve Could not reserve enough space for object heap

by Ed Chen
December 1, 2021December 1, 2021

Tried to execute a Java program like the following: C:\Users\edchen>java -Xmx1500M -cp C:\ERPAPP\jarfiles\* ... ... Error occurred during initialization of VM Could not reserve enough… Read More »

How to Resolve ORA-01156: recovery or flashback in progress may need access to files

by Ed Chen
November 29, 2021December 2, 2021

ORA-01156 Tried to add a standby log file to a database, but it failed with ORA-01156. SQL> alter database add standby logfile thread 1 group… Read More »

How to Resolve ORA-44303: service name exists

by Ed Chen
November 26, 2021December 1, 2021

ORA-44303 Tried to add a service to a database, but it failed with ORA-44303. SQL> exec dbms_service.create_service('ERPAPP1', 'ERPAPP1'); BEGIN dbms_service.create_service('ERPAPP1', 'ERPAPP1'); END; * ERROR at… Read More »

How to Create an Empty Table by CTAS

by Ed Chen
November 24, 2021October 30, 2021

Empty Table To duplicate a table, the fast way is to use CTAS (Create Table As Select). Sometimes, the only thing you want is an… Read More »

How to Resolve dd: 0511-052 A shared memory error occurred

by Ed Chen
November 22, 2021October 30, 2021

0511-052 A shared memory error occurred We have learned that we should use upper-cased letter to specify the unit of block size (bs) in dd… Read More »

Oracle Controlfile Types

by Ed Chen
November 20, 2021November 29, 2021

After solving ORA-01610, you might have a question: how do I know the currently used controlfile is a BACKUP one or not? We take the… Read More »

How to Resolve ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

by Ed Chen
November 19, 2021December 1, 2021

ORA-01610 Tried to perform RECOVER DATABASE on a mounted database by SQL statement, but it failed with ORA-01610. SQL> recover database until cancel; ORA-00283: recovery… Read More »