difference between truncate and delete ,drop?
- 3 Answers
- 6114 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Drop deletes the table along with its structure from the database.
Delete command deletes the records from the table and it also deletes the table space allocated in the database.
Truncate is similar to Delete but it does not delete the table space from the database.
Drop and Truncate are the DDL command hence can't be rolled back whereas Delete is a DML command and can be rolled back.
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / surendra
truncate
it deletes only the records from the table
it doesn't delete the structure of the table
we cannot rollback it
we cannot delete a particular record from the table
it is ddl
drop
it deletes the records as well as structure of the table too
we cannot rollback the records
we can flashback the table from the version 9x
it is ddl
delete
it deletes the only records which are we mention in the where clause or whole records
it is dml
we can rollback it
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / sachin
the main difference between delete and truncate is that in
the truncate u will delete all the values from the table as
well as from the data dictionaries also while delete is used
to delete selected values and in the same way drop is use
to delete whole data from a table but the deleted data will
occupy the memory space in the extents but if we perform
truncate then the extents are free from the deleted data .....
| Is This Answer Correct ? | 0 Yes | 0 No |
How to loop through a cursor variable?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
How to write a left outer join with the where clause in oracle?
Is there a combination of "like" and "in" in sql?
How would you change old and new values in an insert, delete and update triggers?
What is a procedure in oracle?
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.
What is the difference between alert log file and trace file ?
What are the oracle built-in data types?
What would you use to improve performance on an insert statement that places millions of rows into that table?
who is the father of oracle and send chodd rules
what is reindexing?
Oracle General 
