Ed Chen Logic - To Make My Logic More Logical

How to Resolve ORA-01722: invalid number

by Ed Chen
January 22, 2020December 26, 2019

ORA-01722 ORA-01722 means that the arithmetic operation in the statement failed to calculate because one of operands cannot be converted to a valid number implicitly.… Read More »

How to Resolve ORA-01017: invalid username/password; logon denied

by Ed Chen
January 18, 2020January 21, 2020

ORA-01017 ORA-01017 means that you either provided an incorrect username or password, so the database that you tried to connect denied you to logon. SQL>… Read More »

How to Resolve ORA-01000: maximum open cursors exceeded

by Ed Chen
January 15, 2020January 17, 2020

ORA-01000 Saw an error ORA-01000: maximum open cursors exceeded when executing a lot of statements. It seemed that the number of open cursors has reached… Read More »

How to Resolve ORA-01045: user lacks CREATE SESSION privilege; logon denied

by Ed Chen
January 11, 2020January 14, 2020

ORA-01045 means that the user who tried to connect to the database has no privilege to connect. Therefore, the database refused the user to logon.… Read More »

How to Empty an Oracle Database

by Ed Chen
January 8, 2020January 17, 2020

Empty a Database In my case, a phased out database server is going to transfer to another project team, my job is to remove all… Read More »

How to Resolve ORA-28001: the password has expired

by Ed Chen
January 4, 2020January 14, 2020

ORA-28001 ORA-28001 means that your password has been expired according to your profile. Normally, you should change the password, but you can still work around… Read More »

How to Resolve ORA-28000: The account is locked

by Ed Chen
January 1, 2020January 14, 2020

ORA-28000 ORA-28000 means that the account that you tried to use is locked because some privileged user disabled the ability of connection. Therefore, it's an… Read More »

How to Resolve ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

by Ed Chen
December 28, 2019December 29, 2019

ORA-01452 ORA-01452 means that the unique index that you want to impose on columns cannot be created because of duplicate keys have been found. In… Read More »

How to Resolve ORA-01442: column to be modified to NOT NULL is already NOT NULL

by Ed Chen
December 25, 2019December 26, 2019

ORA-01442 ORA-01442 means that the target column is already NOT NULL, you don't have to add it again by modifying the column. I know sometimes… Read More »

How to Resolve ORA-01017 in Database Links

by Ed Chen
December 21, 2019January 21, 2020

ORA-01017 in Database Links Before troubleshooting error ORA-01017, please make sure that every portion of connection string that you provided is correct. Let's me show… Read More »