OraFAQ Forum: Server Utilities » Is it possible database backup tranfer to next version

Home » RDBMS Server » Server Utilities » Is it possible database backup tranfer to next version (oracle 9i)

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

Is it possible database backup tranfer to next version [message #333942]

Mon, 14 July 2008 23:56

mm_kanish05
Messages: 493
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

Report message to a moderator

Re: Is it possible database backup tranfer to next version [message #333943 is a reply to message #333942]

Tue, 15 July 2008 00:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated above

Report message to a moderator

Re: Is it possible database backup tranfer to next version [message #333950 is a reply to message #333942]

Tue, 15 July 2008 00:26

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Use exp to export and imp to import.

Regards
Michel

Report message to a moderator

Re: Is it possible database backup tranfer to next version [message #333952 is a reply to message #333942]

Tue, 15 July 2008 00:37

mm_kanish05
Messages: 493
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

Michel Cadot
Messages: 68650
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

Report message to a moderator

Re: Is it possible database backup tranfer to next version [message #333961 is a reply to message #333942]

Tue, 15 July 2008 00:58

mm_kanish05
Messages: 493
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

Report message to a moderator

Re: Is it possible database backup tranfer to next version [message #333965 is a reply to message #333961]

Tue, 15 July 2008 01:07

Michel Cadot
Messages: 68650
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 09:55:11 CDT 2024