Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vikas
delete is slow because it creates log file while performing delete operations.We can recover data which is removed by using delete command by using rollback.
Truncate is fast because it does not create any log file while performing delete operation.We can not recover data which is removed by using truncate command.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the tools for Oracle ?
What are the built-in functions used for sending Parameters to forms ?
How to fetch the row which has the max value for a column?
How to execute a stored program unit?
What is the relationship among database, tablespace and data file?
How to start your 10g xe server from command line?
What is an oracle data file?
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?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is recovery manager(rman) backup in Oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What is the sql query to concatenate column values from multiple rows in oracle?
Explain the use of log option in exp command.
what is insert all statement in sql
What is set operator oracle?
