Home » RDBMS Server » Server Utilities » Is it possible database backup tranfer to next version (oracle 9i)
Is it possible database backup tranfer to next version [message #333942] Mon, 14 July 2008 23:56 Go to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi

I having all the tables and datas are in Oracle 9i and which is running in linux.

I have the backup in *.tgz file Which we extract through winzip. After extraction it is an dmp file.

Now I having 10g in Windows. I want to import the dmp into 10g.

What are all step to required to achieve this.

My database name is OraAL

Kanish



Re: Is it possible database backup tranfer to next version [message #333943 is a reply to message #333942] Tue, 15 July 2008 00:00 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated above
Re: Is it possible database backup tranfer to next version [message #333950 is a reply to message #333942] Tue, 15 July 2008 00:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use exp to export and imp to import.

Regards
Michel
Re: Is it possible database backup tranfer to next version [message #333952 is a reply to message #333942] Tue, 15 July 2008 00:37 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

you mean

imp expdat.dmp.1507.0813


it asking for password i had
it giving an error.
ora-12560 : TNS adopter error
kanish


[Updated on: Tue, 15 July 2008 00:38]

Report message to a moderator

Re: Is it possible database backup tranfer to next version [message #333960 is a reply to message #333952] Tue, 15 July 2008 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Of course, you have to properly set your environment (oracle_home, oracle_sid...) as for any other import.

Regards
Michel
Re: Is it possible database backup tranfer to next version [message #333961 is a reply to message #333942] Tue, 15 July 2008 00:58 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi Michel,

Thanks 1st.

My dump file expdat.dmp.1507.0813 (is from oracle 9i(linux))

But now i want to do it in 10g which in my local machine(windows xp).

Sorry i zero in this topic please guide me priefly.


kanish


Re: Is it possible database backup tranfer to next version [message #333965 is a reply to message #333961] Tue, 15 July 2008 01:07 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is nothing special to do.
You just have to correctly set your environment as for any other import.
The only thing you have to do is to tranfert your file in binary mode but as it is a compressed one, you did it otherwise you couldn't decompress it.

Regards
Michel
Previous Topic: Imp error: partial import of previous table rolled back
Next Topic: loader loading only the first character
Goto Forum:
  


Current Time: Sat Dec 03 09:43:10 CST 2016

Total time taken to generate the page: 0.13961 seconds