Home » RDBMS Server » Server Utilities » imp/exp (Windows XP 10g 10.0.2.0.1)
imp/exp [message #452758] Fri, 23 April 2010 17:02 Go to next message
keekee
Messages: 19
Registered: April 2010
Junior Member
I try to use rman duplicate database to bring entire databse form Windows XP system to another Windows XP.
I have been trying to use rmain duplicate database without success.
I failed on "startup force nomount......". The system always prompt
me an error as "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor" and following by
TNSLSNR.exe has encountered a problem and need to be close......"

I have tried to re-install the oracle multiple times and failed at
the same problem as above.
So, I am thinking of using imp and exp to do the work. Is it possible? If yes, how to do it.
Thanks
Re: imp/exp [message #452760 is a reply to message #452758] Fri, 23 April 2010 17:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>So, I am thinking of using imp and exp to do the work. Is it possible?

>If yes, how to do it.
exp username/password file=full.dmp full=yes
imp username/password file=full.dmp full=yes
Re: imp/exp [message #452804 is a reply to message #452758] Sat, 24 April 2010 14:36 Go to previous messageGo to next message
keekee
Messages: 19
Registered: April 2010
Junior Member
I want to bring entire database (such as sys, system, scott..)into another Windows XP.
If is use exp username/password ... or imp username/password....
it only bring some part of database over.
Re: imp/exp [message #452805 is a reply to message #452804] Sat, 24 April 2010 14:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Since you know better, I won't waste more time here.

When all else fails, Read The Fine Manual

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm
Re: imp/exp [message #452832 is a reply to message #452804] Sun, 25 April 2010 04:35 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
keekee
it only bring some part of database over.
Which part, exactly?

[Updated on: Sun, 25 April 2010 04:35]

Report message to a moderator

Re: imp/exp [message #453359 is a reply to message #452758] Wed, 28 April 2010 06:29 Go to previous message
lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi
Member
Hi Keekee,
Can you read "full=yes" in exp and imp commented by Blackswan.
When you say full = yes, it means your entire database is exported not a part.
Read the comments carefully before asking the questions again.

Regards
Lalit
Previous Topic: Re: "field in datafile exceeds maximum length" for number field (splilt from hijacked thre
Next Topic: Imp db oracle
Goto Forum:
  


Current Time: Fri Mar 29 03:20:43 CDT 2024