Life as Code

refactoring my life

When importing large Oracle dumps…

leave a comment »

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
About these ads

Written by Bogdan

February 6, 2009 at 7:55 PM

Posted in Development, RDBMS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 264 other followers

%d bloggers like this: