How to Tell AIX Release Number
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 Tell AIX Release Number
How to Resolve ORA-04063: view has errors
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-04063: view has errors
How to Resolve ORA-01720: grant option does not exist
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-01720: grant option does not exist
How to Resolve ORA-00955: name is already used by an existing object
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-00955: name is already used by an existing object
How to Resolve ORA-01400: cannot insert NULL into
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 Resolve ORA-01400: cannot insert NULL into
How to Add or Drop NOT NULL Constraint
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 Add or Drop NOT NULL Constraint
How to Check 32-bit or 64-bit Oracle Client
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 »How to Check 32-bit or 64-bit Oracle Client
How to Migrate Data from 9i to 12c via DB Link
Migrate 9i to 12c As I said in How to Resolve ORA-03134, you cannot directly access an Oracle 9i database from an Oracle 12c or… Read More »How to Migrate Data from 9i to 12c via DB Link
How to Resolve ORA-12899: value too large for column
ORA-12899 ORA-12899 means that the value of being inserted or updated data is larger than column's allowable length that is defined in the table. Let's… Read More »How to Resolve ORA-12899: value too large for column
How to Resolve "Connected to an idle instance"
Connected to an idle instance Actually, Connected to an idle instance is a message rather than an error, it indicates that the database you enter… Read More »How to Resolve "Connected to an idle instance"