Home » RDBMS Server » Server Administration » Migration
Migration [message #263510] Thu, 30 August 2007 04:04 Go to next message
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?
Re: Migration [message #263516 is a reply to message #263510] Thu, 30 August 2007 04:13 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Not possible.
Re: Migration [message #263518 is a reply to message #263510] Thu, 30 August 2007 04:16 Go to previous messageGo to next message
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 )
Re: Migration [message #263521 is a reply to message #263510] Thu, 30 August 2007 04:21 Go to previous messageGo to next message
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
Re: Migration [message #263522 is a reply to message #263510] Thu, 30 August 2007 04:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
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
Re: Migration [message #263524 is a reply to message #263510] Thu, 30 August 2007 04:24 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
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


Re: Migration [message #263529 is a reply to message #263510] Thu, 30 August 2007 04:35 Go to previous messageGo to next message
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.
Re: Migration [message #263537 is a reply to message #263529] Thu, 30 August 2007 04:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
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
Re: Migration [message #263542 is a reply to message #263510] Thu, 30 August 2007 04:55 Go to previous messageGo to next message
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.
Re: Migration [message #263543 is a reply to message #263510] Thu, 30 August 2007 04:59 Go to previous messageGo to next message
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?
Re: Migration [message #263544 is a reply to message #263542] Thu, 30 August 2007 05:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
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


Re: Migration [message #263549 is a reply to message #263510] Thu, 30 August 2007 05:12 Go to previous messageGo to next message
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.
Re: Migration [message #263550 is a reply to message #263510] Thu, 30 August 2007 05:23 Go to previous messageGo to next message
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?
Re: Migration [message #263557 is a reply to message #263510] Thu, 30 August 2007 06:09 Go to previous messageGo to next message
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.
Re: Migration [message #263559 is a reply to message #263510] Thu, 30 August 2007 06:15 Go to previous message
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>
Previous Topic: Status change of a data file without achive log file
Next Topic: Sorting
Goto Forum:
  


Current Time: Fri Dec 09 04:03:02 CST 2016

Total time taken to generate the page: 0.08377 seconds