This content has been marked as final. Show 13 replies
kunle03101980 wrote:expdp from old DB
I am still new here and I am working on a project. I am trying to move a 10g database from Windows to a brand new server with Linux 5. Please what are the steps I need to take?
*The present server (Windows 7) is in noarchivelog mode
*There is basically no connection between this 2 servers
*This is development environment so I have a lot of time to experiment.
impdp into new DB
Can you enable Archivemode on your database and USE RMAN it will be the best way
Thanks, how do I copy the file to the other server since they are not connected together. One is in VA while the other one is in Atlanta.
Will usually export will give file called dmp just copy this folder on usb or external hard disk and put it on the second server1 person found this helpful
Great! So the dmp file can be successful open in Linux even though the export was done in windows?
Yes if you are using expdp and impdp its supposed to work smoothly otherwise you can use "unix2dos and dos2unix" .
Yuo can use RMAN Duplicate target to new d.b. , by allocating auxiliary channels .
Datapump (expdp/impdp) is the way to go. expdp create a 'logical' dump of the database - think of it as just a whole series of create statements and insert statements written to a file. This file is then generic and can be used on any platform. If your shipping it a long way (Not sure how far Virginia is from you other site) you may want to zip it before sending it. At the other end you just need to have create a database 'shell' - i.e. a very basic database which you are then going to create all the objects in (can be different oracle version - with some restrictions). You then use impdp to upload the file and create everything.
You can use Transportable Tablespaces feature.
Thanks> I think transportable tablespaces will be a very good idea. I will work with this and give you feedback next week.
Many thanks folks!
if you think your question is answered, you should mark the post as answered and correct answer.
Thanks folks. I've been able to resolve the issue.
Let the next person with the same issue know how.