Re: Importing and indexing large tables

Alan Jeskins-Powell wrote:
>
> Consider this: 12 tables, average 3 million rows and 4 indexes per table.
> It has become impossible for us to export/import this data in a weekend
> (the only free processing time we have) given the techniques we are
> currently using (std.Oracle exp/imp)
> Does anyone have any ideas on how we can spped the process up so that we
> can a) fit the exp/import into a working weekend and b) still allow time
> for harware/software upgrades as well.

1. Don't do that, I can't think a reason you need to do exp and imp per week.
2. Try exp/imp using NATIVE mode.
3. Try disk mirroring the server and imp/exp the mirrored server.