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

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a user-defined lock?

592


What would you do with an "in-doubt" distributed transaction?

1423


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

548


how can you generate profile of pl/sql applications to identify performance bottlenecks?

605


What are the commands used in dcl? : sql server DBA

585






what is the last version,the release date of that version and fix pack of ibm db2 udb?

1531


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1993


What the different types of replication and why are they used? : sql server DBA

579


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

668


How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2041


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1550


When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

572


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

2201


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2184


what are the performance views in an oracle rac environment?

575