transferring oracle XE database to new computer

Hello,

I am replacing a computer for a Primavera P6 PM user, and trying to get his data moved over. From my understanding if we just export to XER file there are some components that will not transfer, such as baseline and historical data. 

I am proficient in MSSQL and other SQL flavors, and I'm very good at googling up information but have been beating my head against this Oracle XE engine for several hours and I think I am actually further behind than when I started. 

 

Can someone either spell out or link to very comprehensive instructions on backing up and restoring to new hardware? The oracle XE installs are identical on both computer. I've run the backup script and attempted to transfer what I believe is the backup file to the new machine, but the instructions are all incredibly vague. 

 

thanks for your help! 

Z
Zoltan Palffy 👤 Member for 16 years 10 months

yeah Chris double post I knoe becuase it did not show up the first time 

C
Chris Sawatsky 👤 Member for 10 years 6 months

this looks like great instructions, thanks! not sure why I was unable to come up with it via google

 

one thing however, I can't seem to find the script you've mentioned, xe_expimp.zip

 

could you provide a link?

 

thanks again

Forum Sponsor

Top Posters

Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts