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
as stimulating as black coffee and just as hard to sleep after.
Note to self and others!
When importing large oracle dumps (size in GB’s):