Predict one way to avoid such errors in near future.
A. Increase the size of redo log files
B. Increase the size of the undo tablespace
C. Increase the size of the Database Buffer Cache
D. Increase the size of the default temporary tablespace
Answer:A
Predict one way to avoid such errors in near future.
A. Increase the size of redo log files B. Increase the size of the undo tablespace C. Increase the size of the Database Buffer Cache D. Increase the size of the default temporary tablespace
Explanation: The error occur because of size in the undo retention, can be overcome by increasing the size of your rollback segment (undo) size.Also can be resolve by increase the setting of UNDO_RETENTION. Otherwise, use larger rollback segments.