Interview Questions And Answers
Q: - What will be in the redolog file after deleting the table ,will it stores the table or any thing else? Can we resize the redolog files?
A message will be recorded for deleted table.There is no single command to resize an existing set of redo logs.
If you want to resize the redo log groups, then first you need to create some more of redo log file group with the desired name and size. After that you can drop older redolog group.
Submitted By:-Rehman Email-ID: - kumar_rehman@yahoo.com
Q: - What is ORA-1555?
Its an snapshot too old error.
If the data requested by the user is not in the undo segment then the oracle throws an ora-1555. This can beavoided by increasing the undo_retention parameter.
Submitted By:-Rehman Email-ID: - kumar_rehman@yahoo.com
 |
 |