OraFAQ Forum: Server Administration » Mounting a datafile from a different DB.

Home » RDBMS Server » Server Administration » Mounting a datafile from a different DB.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Mounting a datafile from a different DB. [message #55949]

Wed, 26 February 2003 05:19

Theo Horn
Messages: 2
Registered: February 2003

Junior Member

Hi All, I have a datafile from another installation which I want to mount on my current database to get the data stored in it. Is it possible or is there another way of getting the data from a datafile? Oracle 8i on Solaris.

Thanx
Theo

Report message to a moderator

Re: Mounting a datafile from a different DB. [message #55951 is a reply to message #55949]

Wed, 26 February 2003 06:21

Remi
Messages: 28
Registered: December 2002

Junior Member

Hi

The answer is simple; NO

The only way is to export from one database and import it in the other database.

Good luck!

Remi

http://askremi.ora-0000.com

Report message to a moderator

Re: Mounting a datafile from a different DB. [message #55955 is a reply to message #55949]

Wed, 26 February 2003 11:57

ctg
Messages: 146
Registered: July 2002

Senior Member

transportable tablespace (emport/import)

Report message to a moderator

Re: Mounting a datafile from a different DB. [message #55959 is a reply to message #55949]

Wed, 26 February 2003 15:22

Trifon Anguelov
Messages: 514
Registered: June 2002

Senior Member

Control files have datafiles header information. It's not going to match with the information from this datafile, and you will get errors.

In Oracle 9i, there is option TABLESPACES (list of tablespaces to export). Use it to get the data out and then import it to your other db.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

The latest Oracle DBA forums

Report message to a moderator

Re: Mounting a datafile from a different DB. [message #55966 is a reply to message #55949]

Thu, 27 February 2003 00:02

Theo Horn
Messages: 2
Registered: February 2003

Junior Member

Thanx guys, I have only the data file, no control files. Isn't there a way with RMAN to get the stuff out?

Report message to a moderator

Re: Mounting a datafile from a different DB. [message #55968 is a reply to message #55949]

Thu, 27 February 2003 03:10

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

Hello,
It is not possible..
However, u can export/ import from one database and get it into the current database.. But make sure that u will have the same tablespace been existing / created in the local machine before u import.

sai

Report message to a moderator

Re: Mounting a datafile from a different DB. [message #56000 is a reply to message #55968]

Fri, 28 February 2003 05:45

Mike
Messages: 417
Registered: September 1998

Senior Member

If the OS is the same I recommand you to use the transportable tablespace option instead of exporting importing the tablespace data

Report message to a moderator

Previous Topic:	Is it possible to install oracle 8 on windows 2000 professional
Next Topic:	Delete Records Without Table Drop

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 28 20:58:05 CST 2024