delete-low water mark level truncate-high water level

diff between DELETE and TRUNCATE?.

Question Posted / chaitanyabilla

Answer Posted / chaitanyabilla

delete-low water mark level
truncate-high water level

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Oracle

2319

What is a view and how is it different from a table?

969

Which is faster join or subquery in oracle?

932

Can you drop an index associated with a unique or primary key constraint?

967

Where is the export dump file located?

1080

What is difference between truncate and delete?

973

Explain an extent?

1048

How would you go about verifying the network name that the local_listener is currently using?

1994

What is an oracle table?

931

How to create a table index?

1060

How to get a list of all background sessions in the database?

943

Explain self joins in oracle?

949

What is rowid and rownum in oracle?

952

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2209

How can I introduce multiple conditions in like operator?

923