Ed Chen Logic - Page 2 of 76 - To Make My Logic More Logical

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 »

How to Tell AIX Release Number

by Ed Chen
December 11, 2019November 30, 2019

AIX Release Number When we use oslevel command to print the latest installed level of AIX, we saw the release number like this: # oslevel… Read More »

How to Resolve ORA-04063: view has errors

by Ed Chen
December 7, 2019December 30, 2019

ORA-04063 ORA-04063 means that the view you want to grant to someone else has compile error, so the database cannot grant it to other users.… Read More »

How to Resolve ORA-01720: grant option does not exist

by Ed Chen
December 3, 2019February 6, 2020

ORA-01720 Got error ORA-01720 when we tried to grant an object privilege to another user. ORA-01720 means that the grantee doesn't have privileges on the… Read More »

How to Resolve ORA-00955: name is already used by an existing object

by Ed Chen
November 30, 2019December 30, 2019

ORA-00955 ORA-00955 means that the name of the schema object that you tried to create is already used and taken by some other existing schema… Read More »

How to Resolve ORA-01400: cannot insert NULL into

by Ed Chen
November 27, 2019January 17, 2020

ORA-01400 ORA-01400 means that there's a column which was found as NOT NULL is not listed in the INSERT statement, you have to provide a… Read More »

How to Add or Drop NOT NULL Constraint

by Ed Chen
November 23, 2019January 8, 2020

Add NOT NULL Constraint As I mentioned in How to Resolve ORA-00904 for ALTER TABLE ADD CONSTRAINT, NOT NULL is a constraint, but it's more… Read More »

How to Check 32-bit or 64-bit Oracle Client

by Ed Chen
November 20, 2019November 15, 2019

32-bit or 64-bit In some situations, we need to know whether our Oracle client is 32-bit or 64-bit in order to use the right tool… Read More »