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.
Read the rest of this entry »

Advertisements

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.

Read the rest of this entry »

Advertisements
Advertisements