Re: moving an oracle server

From: Tom Zamani <tomz_at_redflex.com.au>
Date: 2000/05/30
Message-ID: <8gutve$i3u$1@perki.connect.com.au>#1/1

I would say there are many ways to do this.

1- On the new server get the oracle runging, create all the table spaces which are in the old server (exact name) 2- export the structure of the old database (all users you can do a full backup as well which will create the table spaces) 3- import the file in to the new server. ### at this stage both databases are the same except data. 4- export the data for all (users)
5- import into the new database.

Tom

<m_w_morrison_at_my-deja.com> wrote in message news:8guqb8$2se$1_at_nnrp1.deja.com...
> Could someone please let me know how I can completely move an oracle
> server (7.3.4.0.0) and all the databases it contains from one computer
> to another computer?
>
> I have tried several ways with little success.
>
> There must be an easy way to do this!
>
> Mike
> ITC
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue May 30 2000 - 00:00:00 CDT