Re: moving database to new computer

What do you mean by schemas? Is there a way to set it up on the one machine so they think they're still on seperate machines. Will I have to resetup tablespaces etc on the one computer? I imagine so.

In article <37A61D39.1143D8DA_at_crl.com>,   "Gary E. Grant" <ggrant_at_crl.com> wrote:
> The quick and dirty method that I could think up is EXP the DB on
Computer1-5
> and then IMP them into schemas comp1, comp2, comp3 ..comp5 on the new
computer.
>
> Gary :-)
>
> itabl7up_at_yahoo.com wrote:
>
> > Does anyone know of any FAQ or info that I can find on moving
databases
> > from 5 seperate computers onto 1. I don't know how complex it would
be
> > or how exactly I would do it. We have our database split among 5
> > computers. Each computer has technically its own database on it
because
> > the database has its own name. I imagine I can't just copy the
tables
> > over to one databse because the links would dissapear. Any help
would
> > be appreciated, thank You.
> > James
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
>
> --
>
> Always glad to be of service,
>
> Gary :-)
>
> ========================================================
> "There is nothing more difficult to take in hand, more perilous to
> conduct or more uncertain in its success, than to take the lead
> in the introduction of a new order of things."
>
> --- Niccollo Machiavelli, The Prince, 1513
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 03 1999 - 18:14:37 CEST