Truncates are DDL and, in a sense, cheat. A truncate moves the High Water Mark of the table back to zero. No row-level locks are taken, no redo or rollback is generated. ... Simple Truncate ... CODE; Oracle Code Library...
www.psoug.org/reference/truncate.html www.psoug.org/reference/truncate.html
When you truncate a table, Oracle Database automatically removes all data in the table's indexes and any materialized view direct-path INSERT information held in association with the table. This information is independent of any materialized view log.
stanford.edu/dept/itss/docs/oracle/10gR2/server.102/b14... stanford.edu/dept/itss/docs/oracle/10gR2/server.102/b14200/statements_10006.htm
The TRUNCATE function (abbreviated as TRUNC) truncates either a number or a datetime value. Because the syntax of the TRUNC function is different depending on the whether it is being used for a number or a date and time value, two separate entries ... Oracle® OLAP DML Reference; 11g Release 1 (11.1); Part Number B28126-03...
download-west.oracle.com/docs/cd/B28359_01/olap.111/b28... download-west.oracle.com/docs/cd/B28359_01/olap.111/b28126/dml_functions_2127.htm
A statement like delete from tablename deletes all records in the table, but it does not free any space (see On table sizes). In order to free the space as well, use truncate. However, a truncate can not be rolled back. ... Oracle executes the following steps for a truncate statement:
www.adp-gmbh.ch/ora/sql/truncate.html www.adp-gmbh.ch/ora/sql/truncate.html
The DB->truncate() method empties the database, discarding all records it contains. The number of records discarded from the database is returned in countp. ... It is an error to call the DB->truncate() method on a database with open cursors.
www.oracle.com/technology/documentation/berkeley-db/db/... www.oracle.com/technology/documentation/berkeley-db/db/api_c/db_truncate.html
Note: When you truncate a table, Oracle automatically deletes all data in the table's indexes and any materialized view direct-load INSERT information held in association with the table.
download.oracle.com/docs/cd/A87860_01/doc/server.817/a8... download.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/state26b.htm
With DELETE you can choose which rows to delete, whereas TRUNCATE and DROP affect the entire object. ... Oracle Database SQL Language Reference for syntax and other information about the TRUNCATE TABLE and TRUNCATE CLUSTER statements...
download.oracle.com/docs/cd/E11882_01/server.112/e10595... download.oracle.com/docs/cd/E11882_01/server.112/e10595/general003.htm
Subject: truncate oracle table in sql server; I created a job to transfer data from a sql server table to an oracle table. It works fine. However, if I run it on a continuous schedule it will continue to duplicate records.
www.lazydba.com/oracle/0__135668.html www.lazydba.com/oracle/0__135668.html
I assume this is for Oracle. I recall I did undo on a truncate table on SQLServer 2005 just a few months ago… ... I remember that when a company I worked for a long time ago changed from Ingres to Oracle there was much hilarity when we discovered that a truncate couldn’t be rolled back.
oraclesponge.wordpress.com/2008/03/17/interviewing-the-... oraclesponge.wordpress.com/2008/03/17/interviewing-the-difference-between-delete-and-truncate/
Kapil -- Thanks for the question regarding "Truncate Partition is very slow", version 9.2.0 ... Oracle shall not be liable for any damages, including, direct, indirect, incidental, special or consequential damages for loss of profits, revenue, data or data use, incurred by you or any third party in connection with the use...
asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTI... asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:490790900346657642