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
What is transparent data encryption? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is the importance of a recovery model? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
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.
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?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
How would you go about verifying the network name that the local_listener is currently using?
internal architecture
What are the commands you'd issue to show the explain plan for "select * from dual"?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What is dbcc? : sql server DBA
how can you connect from 10g user to 11g user??
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.