A step by step guide to using oracle’s impdp datapump over NETWORK LINK
by a novice non linux user
OK there are plenty of web results for how to use impdp but none of them singularly gave a good end to end description of the process.
Some background
My project have been piggybacking on another project’s DB for testing, and now want to move on to their own.
So we needed to copy all common data from the other project’s DB.
Having set up a shiny new oracle install (installing oracle 10.2 xe on suse) here’s what I had to do.
This post has moved to:
http://www.setupsteps.net/2008/07/step-by-step-guide-to-using-impdp-over.html
Kevin and I are currently working with another partner in setting up a new website…
We’ll give more details when its ready to go.
Some of the tech highlights:
We’ve migrated from acegi securit to spring security (pretty straightforward)
Carrying on with our hibernate model
Extending our previous architecture to be more lightweight and more OO-centric – use of worker and helper classes to decouple.
Use of XML to communicate between layers.
Was given a linux server (SUSE 10.3) in work (Dell PowerEdge300SC 512MB RAM) and asked to install Oracle 10.2 XE (oracle-xe-10.2.01.1-1.0.i386.rpm)
Here’s a list of some of the problems and solutions I encountered:
P1. Need to be root to perform the install.
P2. Now that you’ve changed user you may not be able to find where you downloaded everything!
P3. Some dependencies may not be present for the install to go ahead – i had the following issue
“Failed dependencies:
libaio >= 0.3.96 is needed by oracle-xe-10.2.01.1-1.0.i386.rpm
P4. insufficient swapsize (Machine’s was set to 1019, needed 1024, so close but yet so far)
This system does not meet the minimum requirements for swap space. Based on the amount of physical memory available on the system, Oracle Database 10g Express Edition requires 1024 MB of swap space. This system has 1019 MB of swap space. Configure more swap space on the system and retry the installation.
error: %pre(oracle-xe-10.2.01.1-1.0.i386) scriplet failed, exit status 1
error: install: %pre scriptlet failed (2), skipping oracle-xe-10.2.01.1-1.0.
This post has moved to Installing Oracle 10.2 Express Edition (SuSe 10.3) at SetupSteps.net:
http://www.setupsteps.net/2008/07/installing-oracle-102-express-edition.html
