Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, sridhar kumar.

Asked: July 14, 2016 - 9:56 am UTC

Last updated: July 14, 2016 - 12:41 pm UTC

Version: 11.2.0.3.0

Viewed 1000+ times

You Asked

Hi Team,

Could you please help me on how to truncate a table which part of a cluster. I want to truncate a table and getting below error. please help me ASAP. Below is the error:

SQL> truncate table TEST1;
truncate table TEST1
*
ERROR at line 1:
ORA-03292: Table to be truncated is part of a cluster


Regards,
Sridhar

and Chris said...

You can't. This is a restriction of table clusters:

You cannot individually truncate a table that is part of a cluster. You must either truncate the cluster, delete all rows from the table, or drop and re-create the table

http://docs.oracle.com/database/121/SQLRF/statements_10007.htm#SQLRF55434

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

sridhar kumar sahu, July 14, 2016 - 10:19 am UTC

Many many thanks for this reply.
Connor McDonald
July 14, 2016 - 12:41 pm UTC

glad we could help