Analyze Table Validate Structure Cascade Throws Error: ORA-00600:[6754] (Doc ID 2515165.1)

Last updated on MARCH 29, 2019

Applies to:

Symptoms

Attempting to analyze a table with CASCADE option the following error occurs:

This issue was first run into as :
SQL> select * from <table_name>;
select * from <table_name>
  *
ERROR at line 1:
ORA-00904: "<table_name>"."<col1>": invalid identifier

A select from the first column of the table can be executed successfully,but all others columns throw an ora-904.

Analyze command fails only for CASCADE option:

SQL> analyze table <table_name> validate structure;

Table analyzed.

SQL> analyze table <table_name> validate structure cascade;
analyze table <table_name> validate structure cascade
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [6754], [0], [], [], [], [], [], [],[], [], [], []

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.