Home » RDBMS Server » Server Administration » Changing homes
Changing homes [message #303389] Fri, 29 February 2008 02:37 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

At our client side they have installed two oracles (8i and 10g) with different homes.

10g is currently running, If I change the home from the home selector tool will the command prompt connect to the 8i by default when I login as sysdba

Also, I have taken a dump (using EXP command) of oracle 8.1.5.0.0. Can I upload it directly into 10g database?

- Das
Re: Changing homes [message #303398 is a reply to message #303389] Fri, 29 February 2008 03:15 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
What is a home selector tool?
As for the second question,yes you can import 8i data to 10g using 10g import utility.
Re: Changing homes [message #303401 is a reply to message #303398] Fri, 29 February 2008 03:26 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Just like Universal installer there is a GUI that helps us select the home if multiple oracle products are installed..

ok so mean to say that the dump that I have take from 8i (using EXP command) can be imported into 10g without losing any objects and data..?

- Das
Re: Changing homes [message #303402 is a reply to message #303389] Fri, 29 February 2008 03:29 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
yes there should not be any problem
Re: Changing homes [message #303407 is a reply to message #303401] Fri, 29 February 2008 04:27 Go to previous messageGo to next message
Littlefoot
Messages: 20893
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps you'll find it interesting to read what Mohammad Taj has written on his blog; There's a table which will show you which export (or import) utility to use while moving data between different Oracle database versions.
Re: Changing homes [message #303416 is a reply to message #303402] Fri, 29 February 2008 05:24 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

I did the following.

imp das/das file =d.dmp full=yes but it gave me error that no tablespace named ADVANT exists

then I created advant tablespace, advant user and gave it dba rights. Also made advant tablespace as the default tablespace.

again gave the imp command

imp advant/mse file =d.dmp full=yes

This time it gave me a lot of 'table or view does not exist error'. A few tables were created in the advant schema but they do not have any rows and not all the tables have been imported.

am I doing something wrong? could restore command in RMAN be helpful in this. Please help

- Das
Re: Changing homes [message #303473 is a reply to message #303416] Fri, 29 February 2008 08:32 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
durgadas.menon wrote on Fri, 29 February 2008 06:24

imp advant/mse file =d.dmp full=yes

This time it gave me a lot of 'table or view does not exist error'.



Not really helpful. Why don't you post the actual log file.

Quote:
am I doing something wrong? could restore command in RMAN be helpful in this. Please help



RMAN cannot do anything with an export file.

Are you sure you are using the correct version of the exp and imp commands? Maybe the link Ross posted would be helpful here.
Re: Changing homes [message #303559 is a reply to message #303473] Fri, 29 February 2008 14:38 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
The version of IMP, EXP is 10.2 and the dump is in 8i

Can this cause a problem?

- Das
Re: Changing homes [message #303565 is a reply to message #303559] Fri, 29 February 2008 15:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.
10.2 imp understands 8i dump format.

Regards
Michel

[Updated on: Fri, 29 February 2008 15:21]

Report message to a moderator

Re: Changing homes [message #303574 is a reply to message #303565] Fri, 29 February 2008 19:53 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks for the reply.

I came across this error while importing 8i dump into 10g

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

export client uses WE8ISO8859P1 character set
(possible charset conversion)

export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)



From my previous communications I understand that while using IMP dump file

- I need to have the same username in the importing database as it was in the exporting database

but do I need to have the same database name?


Any assistance would be highly appreciated

- Das

Re: Changing homes [message #303578 is a reply to message #303389] Fri, 29 February 2008 20:48 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
>but do I need to have the same database name?
No
Re: Changing homes [message #303582 is a reply to message #303578] Fri, 29 February 2008 21:22 Go to previous message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Guys,

I tried to split my job into two my first imp statement was this

imp advant/mse show=y log=d:\dummp.log file=d:\d.dmp tables=% rows=n indexes=n constraints=n destroy=y

i tried to import only the tables..and it worked fine. I got this message imp succesfully terminated without warnings

then I tried this command

imp advant/mse log=d:\dummp.log file=d:\d.dmp tables=% rows=y indexes=n constraints=n

This was to get the data but I got warnings and data was not imported. The log file is attached

Can anyone tell me what is wrong?

- Das

  • Attachment: dummp.log
    (Size: 51.41KB, Downloaded 154 times)
Previous Topic: Shifting Databases
Next Topic: STARTUP UPGRADE results in error ORA-01157: cannot identify/lock data
Goto Forum:
  


Current Time: Mon Dec 05 06:38:24 CST 2016

Total time taken to generate the page: 0.21447 seconds