Actually I would expect that Sun would suggest the import export over the
datafile move. How big/ how long do you expect it to take. I am not sure
of why you need the incremental. Also, I have actually be quite successful
doing an export to a pipe, and importing. This eliminates the time for the
export. I would say, what ever you are move comfortable doing, do.
--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"A" <A_at_yahoo.com> wrote in message news:394B16F2.73F79DEE_at_yahoo.com...
> We are currently running Oracle 8.0.5.2 on Solaris 2.7 on a Sun E4500.
> Because of rapid growth, we are moving to an Oracle HA/Clustered
> environment on an E10000, and will be running Oracle 8.0.6 (not all of
> our apps run on 8i :-(( ).
> Currently our databases are not large enough to rule out an
> export/import to accomplish the move and upgrade. (One would involve a
> full export/import, and then an outage with incremental export/import,
> all others could be accomplished with just an outage and full
> export/import).
> However, I am not sure if that is the approach that will be recommended
> by Sun Professional Services.
>
> Can anyone provide their views on the pros and cons of just installing
> 8.0.6 on the new E10000 and doing an export/import of the data (which
> would definitely help with some
> tablespace fragmentation on a couple of the db's) , vs. moving the
> datafiles over with an Oracle 8.0.5 install and upgrading?
>
> I would prefer the export/import option, but would like to see others
> views.
>
> TIA
>
>
>
Received on Sun Jun 18 2000 - 00:00:00 CDT
