I have been sent a copy of a database and I need to install/mount it on a
new server. I have the CTL, DBF and LOG files.

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

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

Greg Doherty wrote:
> I have been sent a copy of a database and I need to install/mount it on a
> new server. I have the CTL, DBF and LOG files.
>
> 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
>
> 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
>
>


Don't start a second thread for a topic which you've already asked about
in an earlier thread. I've answered you there.

HJR

You want to migrate your database from 8.1 to 10.1.
If you do this for test (I means you don't work at a compagny's database),
you can try imp/exp utilities, they are installed in your e:\Oracle\bin or
c:\Oracle\product\10.1.0\bin directories. I suppose you have a mall
database.
hth.
yang
dba oracle

"Greg Doherty" <NoSpam@nospam.com> a écrit dans le message de news:
10rhlfomcvqpub2@corp.supernews.com...
> I have been sent a copy of a database and I need to install/mount it on a
> new server. I have the CTL, DBF and LOG files.
>
> 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
>
> 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
>
>