OraFAQ Forum: Client Tools » help to import data from 8i to 10g

Home » Other » Client Tools » help to import data from 8i to 10g

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

help to import data from 8i to 10g [message #320956]

Sat, 17 May 2008 00:29

sunil.madnani
Messages: 36
Registered: March 2007
Location: BHILAI

Member

Hello all Gurus,
I have a dmp file in 8i . and now i want to upgrade my version form 8i to 10G
How to import that data from 8i to 10G. Is it directly possible
by import utility in toad 7.6 .Or it will Give 1 problem Of version Conflict.

It is very urgent.

Regards:
Sunil Madnani

Report message to a moderator

Re: help to import data from 8i to 10g [message #320959 is a reply to message #320956]

Sat, 17 May 2008 00:49

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Create a 10g database and use imp.

Regards
Michel

Report message to a moderator

Re: help to import data from 8i to 10g [message #320961 is a reply to message #320959]

Sat, 17 May 2008 00:52

sunil.madnani
Messages: 36
Registered: March 2007
Location: BHILAI

Member

Thanx Michel,

But i want to know Will it give me any error regarding the version.if i use toad 7.4 and import it.Is is possible.

Regars:
Sunil Madnani

Report message to a moderator

Re: help to import data from 8i to 10g [message #320965 is a reply to message #320961]

Sat, 17 May 2008 01:15

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't use TOAD, I use Oracle basic tools and imp will not return any return regarding version.

Regards
Michel

Report message to a moderator

Re: help to import data from 8i to 10g [message #320969 is a reply to message #320961]

Sat, 17 May 2008 02:39

malikjee
Messages: 80
Registered: May 2007
Location: lahore

Member

HI there!

U may try its alternate to do so, I mean create 10g database then export your 8i database data to concerning that.keep in mind dont try to use advance techniques regarding it.u simply use exp utility and follow the prompt by tool;

Regard;
Fayyaz Malik

Report message to a moderator

Re: help to import data from 8i to 10g [message #320977 is a reply to message #320969]

Sat, 17 May 2008 04:24

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Michel

will not return any return

On topic: export your existing Oracle database using 8i EXP utility version; then import it into 10g using 10g IMP import utility.

Or, generally speaking:
- export: use lowest database version EXP utility involved in this operation
- import: use IMP utility of the target database

Report message to a moderator

Re: help to import data from 8i to 10g [message #321001 is a reply to message #320977]

Sat, 17 May 2008 12:06

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Littlefoot wrote on Sat, 17 May 2008 11:24

Michel

will not return any return

Your emoticon was the appropriate one! Smile

I should reread twice what I write (but given my level of tiredness, I'm not sure I would see it), I meant "will not return any error"

Regards
Michel

Report message to a moderator

Previous Topic:	Integrating with PL/SQL stored procs from Java/J2EE apps
Next Topic:	plsql developer error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 07:18:22 CST 2025