by issuing "alter tablespace begin backup;" what happens to
tablespace?

Answer Posted / kittu

by issuing above statement it freezes tablespace it won't
allow single transaction to datafile. by this time redologs are generated & excessive redologs also

Is This Answer Correct ?    7 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why does Oracle not permit the use of PCTUSED with indexes?

2323


what are the benefits of flashback feature?

589


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1741


what is the use of recording information about current session?

565


how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

2967






What is the difference between clustered and non-clustered index? : sql server DBA

542


How do you open a cluster administrator? : sql server DBA

578


I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1520


What the different components in replication and what is their use? : sql server DBA

533


how can you schedule a job in database?

595


what do you understand by fine-grained auditing?

625


what is the role of dip user in our database?

2044


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3306


what do you understand by flashback feature of oracle?

551


what is a crs resource?

595