Which is faster, Drop or Truncate? Explain

masthan

• May 30th, 2017

Truncate is faster compared to Drop

Rajan

• Mar 17th, 2017

1. TRUNCATE is a DDL command whereas DELETE is a DML command. 2. TRUNCATE is much faster than DELETE. Reason:When you type DELETE.all the data get copied into the Rollback Tablespace first, then del...

Answer Question  Select Best Answer

where we can find block corruption? which view desc block corruption?

phanindra

• Oct 29th, 2014

Simple way is to run
RMAN>block recover corruption list;

Corruption list specifies info of corrupted blocks from v$database_block_corruption

naveenkumar

• Apr 3rd, 2012

We can find corrupted block by this command in sql>select * from database_block_corruption;

we can also find the corrupted block from unix command by database verify $ dbv file=path block size=8192;

Answer Question  Select Best Answer