Restrictions

The TRUNCATE statement fails if any of the following conditions exist: 4

4
• The user does not have Delete privilege on the table.
4
• The table has an enabled Delete trigger, but the user lacks the Alter 4privilege.
4
• The specified table or synonym does not exist in the local database.
4
• The specified synonym does not reference a table in the local database.
4
• The statement specifies a synonym for a local table, but the USETABLENAME environment variable is set.
4
• The statement specifies the name of a view or a synonym for a view.
4
• The table is a system catalog table or a system-monitoring interface (SMI) 4table.
4
• An R-tree index is defined on the table.
4
• The table is a virtual table (or has a virtual-index interface) for which 4no valid am_truncate access method exists in the database.
4
• An Enterprise Replication replicate is defined on the table.
4
• A shared or exclusive lock on the table already exists.
4
• One or more cursors are open on the table.
4
• A concurrent session with Dirty Read isolation level is reading the table.
4
• Another table, with at least one row, has an enabled foreign-key constraint 4on the specified table. (An enabled foreign key constraint of another table 4that has no rows, however, has no effect on a TRUNCATE operation.)

Related Information