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
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
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
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
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
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
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
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"