Re: Oracle XE backup and restore to transfer data to another server

From: gazzag <>
Date: Thu, 10 Mar 2011 03:53:26 -0800 (PST)
Message-ID: <>

On Mar 9, 1:34 pm, syd_p <> wrote:
> Hmm Thanks. Had a look thro the URL
> I realise now what I really want to do is to back up a schema on one
> box and then restore on another box which has a out of the box
> install of XE.
> Seems like Data Pump Export and Data Pump Import is the way to go.
> Am I right?
> -Syd

Yes, expdp the required schema(s) from the source database, copy the dumpfiles across to the server of the target database and use impdp to import them. The impdp utility will create the required schema(s) and import into them.

-g Received on Thu Mar 10 2011 - 05:53:26 CST

Original text of this message