One question if we put this command "alter tablespace xyz database begin backup;" Is it going to freeze the tablespace.
I am not sure about this.
Kindly provide your suggestion for the same.
No Comments Posted for this Article.
Alter Database to End Backup
Hi Guys, Consider user is updating table. When we issue, alter database begins backup, More redo is generated here . Datafile header is frozen with latest SCN I did backup at os...
Oracle Locally Managed Table Spaces
Default table spaces from 10g which manage the extents locally instead of dictionary management.. It collase the space that is left in all the extents before allocating an extent. It reduces...
reduce table space
hi all, i am new to the BASIS, our Manager asked me to a procedure for reduce the table space. kindly help me for below issue. PSAPSID size 2.5TB-...