Re: Attach a database in Oracle 10g

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:41b8d60f$0$1293$afc38c87_at_news.optusnet.com.au...
> Greg Doherty wrote:
> > Sorry about being vague.
> >
> > Here are the specifics:
> >
> > The database was originally called asfserver located at
> > E:\Oracle\oradata\asfserver\
> > It is a version 8.1 database.
> >
> > I would like to set up this database on a new Oracle 10g (ver 10.1)
server
> > at C:\Oracle\product\10.1.0\oradata\asfserver
> > I have the CTL, DBF and LOG files.
> >
> > What actions/commands do I need to perform to mount this database on my
> > server so that I can access it via SQLPlus, ODBC, etc.
> >
> > TIA,
> > - Greg
>
>
> Right. That puts rather a different perspective on it. There's no easy
> way of doing it. The steps I outlined before assumed E: was still E: and
> (rather more importantly) 8i was still 8i.
>
> You can't simply attach a 10g instance/service to an 8i database. Not
> without fireworks, anyway. You'll have to upgrade the thing properly,
> following all the steps in the Oracle 10g upgrade documentation (see
> http://tahiti.oracle.com).
>
> The move from E: to C: is trivial: you get to the mount state, and you
> issue lots of
>
> alter database rename file 'e:\wherever\filename' to
'c:\wherever\filename';
>
> commands. Use select name from v$datafile to see where the control file
> *thinks* the files are, and to check that you've correctly told the
> controlfile about their en masse relocation. Then you alter database open.
>
> But you'll have to do all of that with an 8i instance. Once you've got
> it working as an 8i database, then think about upgrading.
>
> Regards
> HJR
OK, that throws a spanner in the works.

I have tracked down Oracle 8i and am in the process of installing it.

Once I have it installed, how do I go about installing and mounting my database, so I can begin with the "alter database" commands?

Also, for future reference, is there a better way to transfer databases? Is there some procedure that I can ask the owners of the database to perform so that what they send to me is in a simpler format for me to install? e.g. Some sort of backup at their end that I can simply restore here, perhaps?

Thanks,
- Greg Received on Thu Dec 09 2004 - 17:58:16 CST