OraFAQ Forum: Server Administration » Migration

Home » RDBMS Server » Server Administration » Migration

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

Migration [message #263510]

Thu, 30 August 2007 04:04

ara.oracle
Messages: 142
Registered: August 2007

Senior Member

this is customer requirement.

they had oracle 8i database on windows 2003 platform
and the had the some datas in CD as .dmt file as dump.
they want to load the datas from cd to the existing database.

if those dumps are taken from 10g version of oracle,can it be
able to load the datas in the database.

if we can load ,guide me how to do that?

Report message to a moderator

Re: Migration [message #263516 is a reply to message #263510]

Thu, 30 August 2007 04:13

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Not possible.

Report message to a moderator

Re: Migration [message #263518 is a reply to message #263510]

Thu, 30 August 2007 04:16

NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad

Member

I dont think so...The export from 10g cant be imported to 8i database. But the reverse is possible...i.e. 8i exports can be imported to 10g database. ( backward compatibility )

Report message to a moderator

Re: Migration [message #263521 is a reply to message #263510]

Thu, 30 August 2007 04:21

ara.oracle
Messages: 142
Registered: August 2007

Senior Member

sorry the dump file was taken from oracle 8i database only?
they want to load the datas from cd to the existing database.
guide me briefly how to do tat.its very urgent

Report message to a moderator

Re: Migration [message #263522 is a reply to message #263510]

Thu, 30 August 2007 04:22

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

Senior Member
Account Moderator

It can be if export was made with 8i exp binary (program).

Regards
Michel

Report message to a moderator

Re: Migration [message #263524 is a reply to message #263510]

Thu, 30 August 2007 04:24

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

NandKumar, Who says you that they are export file? They may be simply data file copy.

By the way,if it is taken using exp of 10g and also

Quote:

if those dumps are taken from 10g version of oracle,can it be
able to load the datas in the database.

and you want to in 8i not possible.

[Updated on: Thu, 30 August 2007 04:25]

Report message to a moderator

Re: Migration [message #263527 is a reply to message #263524]

Thu, 30 August 2007 04:30

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

Senior Member
Account Moderator

Michel Cadot wrote on Thu, 30 August 2007 11:22

It can be if export was made with 8i exp binary (program).

Regards
Michel

Report message to a moderator

Re: Migration [message #263529 is a reply to message #263510]

Thu, 30 August 2007 04:35

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Michel , I have seen a point in forum . When I submit my prior thread (before this one in this topic) I saw ara.oracle has not posted 2nd one and also you don't.Only NandKumar. But after several
refresh suddenly I saw his post and your post prior to mine one. I notice this things many more times.

Report message to a moderator

Re: Migration [message #263537 is a reply to message #263529]

Thu, 30 August 2007 04:48

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

Senior Member
Account Moderator

Because we wrote the replies at the same.
You clicked on "Reply" when I was writing my post, before I clicked on "Submit reply". So you don't see my answer.
Then I submit my reply when you were writing your answer, you still don't see my answer.
After you submitted your answer you can see both answers yours and mine (or the opposite in chronological order).

Regards
Michel

Report message to a moderator

Re: Migration [message #263542 is a reply to message #263510]

Thu, 30 August 2007 04:55

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

No, Michel the thing is,Consider the order.

Arju
Michel

Now I submit my post and saw

Arju
Michel
Arju

Then I went in other page and after sometime I came back this page and now the order is changed as

Arju
Michel
Nand
Arju

Though I saw it like 2nd one. After that I have not wrote any thread.But Nand one is in the middle that does not match as I seen.

Report message to a moderator

Re: Migration [message #263543 is a reply to message #263510]

Thu, 30 August 2007 04:59

ara.oracle
Messages: 142
Registered: August 2007

Senior Member

if suppose that dump consists of datafile ,can it be loaded in the database.say me how to load those datafiles and how to start the service?

Report message to a moderator

Re: Migration [message #263544 is a reply to message #263542]

Thu, 30 August 2007 05:02

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

Senior Member
Account Moderator

This is the mystery of concurrency in MySQL.
Maybe this is something like.
You see
Arju
Michel
Arju
because you see committed things and yours (committed or not).
Then
Arju
Michel
Nand
Arju
because Nand committed and his thread was created before but not committed when you previously refreshed.
But this is in term of Oracle concurrency. I don't know how it works in MySQL one.

Regards
Michel

Report message to a moderator

Re: Migration [message #263549 is a reply to message #263510]

Thu, 30 August 2007 05:12

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

if suppose that dump consists of datafile ,

Yes, I also supposed this from beginning and answer is like beginning.

Report message to a moderator

Re: Migration [message #263550 is a reply to message #263510]

Thu, 30 August 2007 05:23

ara.oracle
Messages: 142
Registered: August 2007

Senior Member

arju am asking if the dump file wqas taken from the 8i database itself how to load into the existing database?
can we able to load the dump file only if it was .dmt file or can i able to load if it was simple datafile copy like what you say?

Report message to a moderator

Re: Migration [message #263557 is a reply to message #263510]

Thu, 30 August 2007 06:09

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Data file of one database can't be used in another database.
So you can't. It's not possible.

Report message to a moderator

Re: Migration [message #263559 is a reply to message #263510]

Thu, 30 August 2007 06:15

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

You asked them to give you a dump file that will be taken by emp(8i binary) command. Then you can load it in your database
using
imp username/pass full=y file= <your dump file name>

Report message to a moderator

Previous Topic:	Status change of a data file without achive log file
Next Topic:	Sorting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 07:37:50 CDT 2024