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 |
State all possible different index configurations a table can possibly have?
What is an oracle transaction?
Do View contain Data ?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Is there a function to split a string in plsql?
How to Identify the previously inserted/updated records in already populated table.
What is index-organized table in Oracle?
Can we insert data in view oracle?
What are the original export and import utilities?
How to shutdown your 10g xe server from command line?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is the quickest way to fetch the data from a table?