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
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What are the varoius components of physical database structure of oracle database?
Explain about the analyze command in oracle?
What is a snapshot log?
how to clone 9i Database on to 10g Database.
Why do we need oracle client?
Explain the use of analyse option in exp command.
What are the parameters that we can pass through a stored procedure?
Design database draw er diagram for a certain scenario ?
Differentiate between function and procedure in oracle.
What are the original export and import utilities?
What is the exact use of Collections?
what happened to the global index when I truncate the data in one of the partition?
How to define default values for formal parameters?
How to calculate date and time differences in oracle?