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?
No Answer is Posted For this Question
Be the First to Post Answer
I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........
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.
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What is blocking and how would you troubleshoot it?
What is transparent data encryption? : sql server DBA
Name a tablespace automatically created when you create a database.
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
what is logical system in sap basis
Name two files used for network connection to a database.
suppose you want to audit specific activities on sensitive data. How can you achieve that?
the process of adding a cpu in sql server is called..?
if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?