Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: move all schemas from one server to another

Re: move all schemas from one server to another

From: M.RAMBELOSON <MRambeloson_at_free.fr>
Date: Sat, 20 Jan 2001 00:34:42 GMT
Message-ID: <3A68DC37.802FEAC9@free.fr>

Hi,

A simple export/import of all your schemas would work fine ! The tablespaces (if you have defined specifically any) and Oracle users need to be created on the target instance prior to your import . Max.

John Dunn wrote:

> Just got a new machine with 8i on it and want to copy all my schemas from
> the old machine(8.0.5)
>
> What is the best way to do it?
>
> John
  Received on Fri Jan 19 2001 - 18:34:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US