Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: move all schemas from one server to another
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