Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
When an object is incorrectly compiled, it is necessary to determine what this error is and to correct the error. You can view this error from sqlplus as follows.
For example, let’s assume that there is an error when compiling or creating a view.
1 2 3 | SQL> alter view SYS.KU$_RADM_FPTM_VIEW compile; Warning: View altered with compilation errors. |
We can see what is the error in the above object is as follows.
1 2 3 4 5 6 | SQL> show errors view SYS.KU$_RADM_FPTM_VIEW; Errors for VIEW SYS.KU$_RADM_FPTM_VIEW: LINE/COL ERROR -------- ----------------------------------------------------------------- 0/0 ORA-00932: inconsistent datatypes: expected NCHAR got NCHAR |
