difference between truncate and delete ,drop?
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 |
What is bulk copy or bcp in oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
Differnce between view and index
what is a Nested Loop join?
What is an oracle function?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
how to insert data into partitioned table partition done by Range partition
how do get database name at sql prompt?
What are dml statements in oracle?
What are group functions in oracle?
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
How you open and close a cursor variable.Why it is required?