السلام عليكم ورحمة الله وبركاته،،

!! as we know the REUSE option lets the Oracle Server reuse the datafile


?1stly how
? (its deallocate the old segments (the old data is lost

2ndly
?in which scenario(s) the REUSE option is used with a DataFile

salaam
it actually format the file so datafile become as just new one created.
u can use reuse option any time insteed of size option in datafile clause like
alter tablespace z add datafile '...' reuse;

thanx a lot ya Barwas
"ma ga9art"

تم تعديل 19 مارس 200520 سنة بواسطة عروة