diff between DELETE and TRUNCATE?.
- 14 Answers
- 18137 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / kumar
DELETE TABLE is a logged operation, so the deletion of each
row gets logged in the transaction log, which makes it
slow.
TRUNCATE TABLE also deletes all the rows in a table, but it
won't log the deletion of each row, instead it logs the
deallocation of the data pages of the table, which makes it
faster.
The records deleted through DELETE can be roll backed.
The records deleted through TRUNCATE can't be roll back.
If we are using TRUNCATE ina Transaction then only we can
do the roll back else not.
Both will delete the data but not the stucture of the table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is archive log in Oracle?
What is the relationship among database, tablespace and data file?
What is the difference between "as" and "is" in an oracle stored procedure?
What is oracle database client?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
please explain.. DB architecture ...
Explain temporal data types in oracle
what is normalisation?what are its uses?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What would you do with an in-doubt distributed transaction?
How to create id with auto_increment on oracle?
What language does oracle use?
How to start your 10g xe server from command line?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is raw datatype?
