Answer Posted / ashok
increase the size of undo tablespace
increase retention period
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what are the types of connection load-balancing?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you connect from 10g user to 11g user??
What the different topologies in which replication can be configured? : sql server DBA
how can you communicate with operating system files from oracle?
how can you initialize log miner?
What are the recovery models for a database? : 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 get actual data change values from previous transactions in oracle?
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?
Explain materialized views and how they are used.
what is logical system in sap basis
What are statistics, under what circumstances they go out of date, how do you update them?
what are the benefits of flashback feature?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.