CTS int questions:
1.Temperory tablespace corrupted,how to resolve?If you need
to recover?
2.In tablespace begin backup mode,Its possible to add the
datafile?
3.How to partition the table using Hash partioning,what
happened internally?
4.During rman backup,some files are missing Rman will
continue the backup?
5.what are the errors occurs frequently?
6.which join method is best?why?
7.how to solve deadlock errors?
please reply anyone....
regards
siva
Answer Posted / ashok
1) no need to recover a temperory tablespace .if it is
corrupted we create a new temporary tablespace assign that
tablespace to database
2) yes we can add a datafile when tablespace in begin
backup mode also
4)yes
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
how to restore files with rman?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
how can you create a user-defined lock?
what is logical system in sap basis
how can you connect from 10g user to 11g user??
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 view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How would you extract DDL of a table without using a GUI tool?
What the different topologies in which replication can be configured? : sql server DBA
What is dcl? : sql server DBA
how does an oracle clusterware manage crs resources?
What purpose does the model database server? : sql server DBA
what is a user-defined lock?
Where do you find the default index fill factor and how to change it? : sql server DBA