Interested to Buy Any Domain ? << Click Here >> for more details...
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
How do you trace the traffic hitting a sql server? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
how can you initialize log miner?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is fill factor? : sql server DBA
What purpose does the model database server? : sql server DBA
how to restore files with rman?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What is the difference between dropping a database and taking a database offline? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the commands used in dcl? : sql server DBA
what is a crs resource?
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.
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
