You are currently browsing the tag archive for the ‘ORA-00942’ tag.

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 with a DDL or DML statement is met with an ORA-02030 error.

Only SYS can query the X$ tables, they cannot be granted.  However, you can create view on them and grant the view.
Yazının devamını oku »


I face with ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified error message during making Export table from RAC database to RAC database on AIX 6.1.

Yazının devamını oku »