Re: Attach a database in Oracle 10g

I believe it to be a complete database (consisting of CTL, DBF and LOG files). I followed the procedure specified by Howard and the database instance now loaded, but I am unable to get any king of access via SQL Plus. The owners of the database sent me the user names an passwords that they use, but I have no luck with them (I'm guessing that these are application usernames and passwords, not database one).

Since I have put this database in a directory path that is not the same as where it originally came from, are there some other setting that I need to change?

Thanks,
- Greg

"HansF" <News.Hans_at_telus.net> wrote in message news:pan.2004.12.08.04.10.40.444619_at_telus.net...
> On Tue, 07 Dec 2004 17:42:57 -0800, Greg Doherty wrote:
>
>> Hi,
>>
>> I have been sent a copy of a database and would like to be able to access
>> it. I copied it to a subdirectory under the oradata directory. I'm
>> using
>> WinXP and Oracle 10g. How do I go about attaching to this database? I
>> can
>> use the Database Configuration Assistant to create a new database, but I
>> can't find a way to attach to an existing one.
>>
>> Thanks,
>> - Greg
>
> Please define what you mean by 'database'.
>
> Sadly the term is heavily overloaded in our industry. For example, if you
> have MS SQLServer background, the term database is roughly equivalent to
> an Oracle 'schema'.
>
> If you have received a complete database, then you should have datafiles,
> control files, log files.
>
> If you have received a transportable tablespace, you should have one of
> more data files and an export file containing the 'metadata' alowing an
> existing Oracle database instance to access the tablespace.
>
> Otherwise I simply do not understand what you have received and can not
> envision an easy way to 'attach' it.
>
> /Hans
Received on Wed Dec 08 2004 - 17:01:45 CST