Interested to Buy Any Domain ? << Click Here >> for more details...
by issuing "alter tablespace begin backup;" what happens to
tablespace?
- 5 Answers
- 9337 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. by this time redologs are generated & excessive redologs also
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
Where do you find the default index fill factor and how to change it? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
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?
Why would you call update statistics? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
how can you connect from 10g user to 11g user??
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
How do you trace the traffic hitting a sql server? : sql server DBA
What is dcl? : sql server DBA
what is asm?
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 are statistics, under what circumstances they go out of date, how do you update them?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
