ORA-00942
-
How To Give Grant Select On X$ Objects In Oracle
The X$ tables are owned by the SYS database user and are read-only, which is why they are referred to as fixed tables and the V$ views are referred to as fixed views. This statement might be a juicy invitation for you to try to verify this read-only property. Any attempt to alter these tables Continue reading
-
ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
I face with ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified error message during making Export table from 11.2.0.2 RAC database to 11.2.0.1 RAC database on AIX 6.1. Continue reading
