ORA-02032: When Truncate / Drop Table Command is Run
(Doc ID 444562.1)
Last updated on JANUARY 05, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.5 and laterInformation in this document applies to any platform.
Symptoms
When trying to Truncate or drop tables, we get following Errors
SQL> drop table <>.<>;
drop table <>.<>
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-02032: clustered tables cannot be used before the cluster index is built
drop table <
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-02032: clustered tables cannot be used before the cluster index is built
Running catalog.sql and catproc.sql also will not solve the problem.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |