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...
Oracle Database Interview Questions and Answers
1. On which component can I open an SAP message if there are problems with the Oracle database?The following components are available:BC-DB-ORA: OracleBC-DB-ORA-DBA: BR*TOOLS for the database...