Re: need advice, upgrading 7.3.4 to 10g

JSchneider wrote:
> Just thought I'd post what I ended up deciding on...
>
> Planning to go with a hybrid approach using both exp/imp and SQL*Plus
> COPY. Using 7.3.4 exp and 10g imp with ROWS=N to get the schema and
> all the various objects that might exist. All this is done while the
> production system is online.
>
> Then, we only need downtime to run a script that uses the 8i SQL*Plus
> COPY command to move all the data from the 7.3.4 DB to the 10g DB.
> (This also prevents moving the data two or three times which would most
> likely be necessary with exp/imp.)

Might I inquire why COPY rather than CTAS with the table properties from the exp?

jg

--
@home.com is bogus.
"You're a slut!  I'm a slut!  We're all sluts!" - Terri Nunn at OOW
http://www.berlin80s.com/terri.html