When importing large Oracle dumps…
Note to self and others!
When importing large oracle dumps (size in GB’s):
- start early
- always disable ARCHIVELOG….always
- set UNDO retention to a small value, let’s say 5 seconds
- get coffee…
- wait
- remember to enable ARCHIVELOG… when in production
