Re: Help! Moving 60GB O7.3 db from HP-UX to AIX

Larry Monack wrote:
>
> We're planning on migrating our 60GB data warehouse from an HP box to an
> IBM/RISC. We're wondering if there are any reliable alternatives to the
> full database export/import method. Any advice would be greatly
> appreciated...
> Larry Monack
> F. Schumacher & Co.
> 302/454-3143
> lmonack_at_fsco.com

We have used the following technique successfully...

1. Full export data = no
2. Pre-create db
3. Pre-create tablespaces
4. Unload old data to flat files
5. Run import
6. Load data sqlldr (direct=true)
7. Build indexes with paralell and unrecoverable

Cheers

-- 
Connor McDonald
Systems Administrator-Unix/Oracle
BHP Iron Ore
"You're not drunk if you can lie on the floor without holding on"
            - Dean Martin