Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is a snapshot log?
Explain a private synonyms?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
Is the After report trigger fired if the report execution fails ?
What is a nested table?
What are the differences between date and timestamp in oracle?
How to get the Installed Oracle Version Information ?
How to store only time; not date and time?
What is key preserved table?
How to select an oracle system id (sid)?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is recovery manager(rman) backup in Oracle?
How translate command is different from replace?
How remove data files before opening a database?
What's dateware house and what's clustor with practicle example
