OraFAQ Forum: Server Administration » Questions to Import DB in 8.1.7.4

Home » RDBMS Server » Server Administration » Questions to Import DB in 8.1.7.4

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

Questions to Import DB in 8.1.7.4 [message #56938]

Thu, 08 May 2003 06:50

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi All,
we've to grade up one of our databases for test purposes on a second machine. The original DB is 8.1.7.0 and the destination will be 8.1.7.4. I install the 8.1.7.0 and the Patch to 8.1.7.4 on our destination, then we'll take an export of the target-database.
My Problem is that we have to change the directories on the destination, so I guess that I have to change some entries in the export file and re-generate the controlfiles.
Am I wrong, or did I forget something to do before/during import.
We suggest to use export/import because with rman we have to do some more extra-work (in mind of out backup/recovery-manager) as we've with exp/imp.

Any suggestions/helps welcome
regards
Uwe

Report message to a moderator

Re: Questions to Import DB in 8.1.7.4 [message #56939 is a reply to message #56938]

Thu, 08 May 2003 07:31

Chakravarthy
Messages: 8
Registered: November 2000

Junior Member

Hey Uwe,
Change the path during the import! That's enough

Report message to a moderator

Re: Questions to Import DB in 8.1.7.4 [message #56940 is a reply to message #56939]

Thu, 08 May 2003 07:49

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

I hope I got all path's because we've 6 different path in in original an only 3 in test

Report message to a moderator

Re: Questions to Import DB in 8.1.7.4 [message #56941 is a reply to message #56938]

Thu, 08 May 2003 07:51

Sanjay
Messages: 236
Registered: July 2000

Senior Member

You are planning to do Export/Import and what directories are you talking about ?

This comes into the picture if you are cloning the database.

Import is an import. What is important is how the new DB is set and what the default TS is.

Am I missing something here ?

Regards.

Report message to a moderator

Re: Questions to Import DB in 8.1.7.4 [message #56942 is a reply to message #56940]

Thu, 08 May 2003 07:55

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Uwe,
I dont understand ur requiremtnt or I must be missing something big.
export / import is does not look into control files etc.
export the source
install the second database.
CREATE the similiar tablespaces and users
import to target.

Report message to a moderator

Re: Questions to Import DB in 8.1.7.4 [message #57027 is a reply to message #56938]

Thu, 15 May 2003 04:13

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Thanks for your suggestions. It works fine and I'm online again with the 8.1.7.4

cheerio
Uwe

Report message to a moderator

Previous Topic:	oracle 9i on Mac OSX
Next Topic:	Cron Job

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 30 17:38:51 CST 2024