Re: using migration assistant

"Glen A Stromquist" <glen_stromquist_at_nospam.yahoo.com> wrote in message news:RDpO8.14270$Aa4.760683_at_news0.telusplanet.net...
> I'm about to upgrade a 7.3.3 database to 8.1.7 and since I have a bit of
> time to do this,I am considering using the migration assistant rather then
> export/import.
>
> However, I notice that the migration assistant only lists the instances
> that I have on the machine itself running as services, which makes no
sense
> to me, why would I have a 7.x instance running on my 8.1.7 box? There
> doesnt seem to be a way to point the assistant at the 7.3 instance on a
> different machine. I want to do this more for seeing how it works as much
> as anything.
>
> It looks like I may just use import/export in any case, but still would
> like to try this...
>
>
> TIA
The migration assistants migrates databases 'in situ', so you don't get a new database out of it, either on the same machine or on a different machine. If you didn't install 8.1.7 on the same server as 7.3.3, you can only use export/import to migrate.
I would consider export/import the preferred method anyway:

- if you screw up, you still have the old database
- you reorganize the database at the same time
- all your 7.3 rowids have been converted to 8+ format.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address