Quote Originally Posted by Nugpot
Tamilselvan,

It takes a total of 2 hrs to put all the tablespaces in backup mode.

Regards
Vijay
Why do you want to put all tablespaces in "BACKUP" mode? You will see more redo will be generated if concurrent transactions do DML activities.

I suspect the "gap" in tablespace numbers causes a problem.

Tamil