Database Management Question: Download Database Management PDF
What is the difference between delete and truncate?
Answer:
Truncate is a DDL command, which has autocommit hence
cant be rolled back where as delete is DML with user commit
& roll back option. Truncate is faster then delete since it
wont store any data to backup tablespace. before delting.
cant be rolled back where as delete is DML with user commit
& roll back option. Truncate is faster then delete since it
wont store any data to backup tablespace. before delting.
| Previous Question | Next Question |
| What is the difference between oracle CPU and PSU? | What is ORACLE CLINICAL? |