Interested to Buy Any Domain ? << Click Here >> for more details...
by issuing "alter tablespace begin backup;" what happens to
tablespace?
- 5 Answers
- 9302 Views
- CSC, Logica CMG, I also Faced
- E-Mail Answers
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
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?
what is logical system in sap basis
What is replication? : sql server DBA
What is the default fill factor value? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is the difference between dropping a database and taking a database offline? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what is asm?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Why would you use sql agent? : sql server DBA
how can you create a user-defined lock?
How can you control the amount of free space in your index pages? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What is transparent data encryption? : sql server DBA
