Adsense Ad

Thursday, 25 May 2017

Oracle: ORA-00948 Error Message

ORA-00948 Error Message

Learn the cause and how to resolve the ORA-00948 error message in Oracle.

Description

When you encounter an ORA-00948 error, the following error message will appear:
  • ORA-00948: ALTER CLUSTER statement no longer supported

Cause

You tried to execute an ALTER CLUSTER statement, but this statement is no longer supported.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

Try adding your cluster from an existing table.
For example:
CREATE TABLE new_table
  SELECT *
  FROM old_table CLUSTER cluster_name;

DROP old_table;

RENAME TABLE new_table old_table;

No comments: