Interested to Buy Any Domain ? << Click Here >> for more details...
by issuing "alter tablespace begin backup;" what happens to
tablespace?
- 5 Answers
- 9285 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
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Query processing is slow(eg select query)how will u solve that
What is dbcc? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
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
how can you record information about current session?
how to restore files with rman?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : 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.
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How would you best determine why your MVIEW couldn't FAST REFRESH?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
