| Changing homes [message #303389] |
Fri, 29 February 2008 02:37  |
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 #303401 is a reply to message #303398] |
Fri, 29 February 2008 03:26  |
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 #303416 is a reply to message #303402] |
Fri, 29 February 2008 05:24 |
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 |
joy_division
Messages: 4963
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 #303574 is a reply to message #303565] |
Fri, 29 February 2008 19:53 |
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 #303582 is a reply to message #303578] |
Fri, 29 February 2008 21:22 |
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 982 times)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
