Wow - it's been a month since my last blog entry. Time flies!
If you read Part I, you've already analyzed your data and designed your Type II storage areas and you're ready to dump your existing data and load it into the new structure. If you're still using Type I storage areas, this will probably be the slowest part of the entire D&L process so don't despair. The load and the index rebuild should take considerably less time than the dump.
You have three choices when it comes to dumping your data:
- ASCII Dictionary Dump
- ASCII Custom Dump
- Binary Dump
This blog post is going to concentrate on the binary dump as that's what most of you are going to use. Unless the database is very small or you need to do some conversions during the dump, there's really no reason to use the dictionary dump for anything other than users and sequence current values.