TRUNCATE Statement

Remove ALL rows from a table or cluster.

Syntax:

   TRUNCATE TABLE [schema.]table 
     [{PRESERVE|PURGE} MATERIALIZED VIEW LOG]
        [{DROP | REUSE} STORAGE]

   TRUNCATE CLUSTER [schema.]cluster 
        [{DROP | REUSE} STORAGE]

For backwards compatibility, the terms "snapshot" and "materialized view" are synonymous.

"A clever man commits no minor blunders" ~ Goethe

Related Oracle Commands:

Trunc function
DELETE
INSERT
SELECT
UPDATE

Related Views:

  DBA_CLUSTERS         ALL_CLUSTERS         USER_CLUSTERS        
  DBA_CLUSTER_HASH_EXPRESSIONS              USER_CLUSTER_HASH_EXPRESSIONS 
                       ALL_CLUSTER_HASH_EXPRESSIONS 

  DBA_ALL_TABLES       ALL_ALL_TABLES       USER_ALL_TABLES
  DBA_TABLES           ALL_TABLES           USER_TABLES         TAB
                                                                DICTIONARY
                                                                DICT_COLUMNS

 
Copyright © 1999-2024 SS64.com
Some rights reserved