Skip to Main Content

Breadcrumb

Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions

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
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.