Re: Copying live to test database

I am also trying to make an exact copy of a database on a different server. I would think that copying everything in the DATABASE directory to the second server would work but I get an error when trying to connect using SQL Plus. I am using Oracle Workgroup server 7.3 on NT.

Any ideas on what I am missing?

• Steven Peterson

Adrian Hands wrote:

> MTaylo1987 wrote:
> >
> > I would like a method whereby I can copy all the data in my Live database to
> > the test one. Iam aware an export/import wo do the job but it is rather long
> > winded.
> >
> > Are there any other ways of achieving this.
> >
> > Note The test database will not be in use at the time the copy occurrs.
>
> You can copy the .dbf files if you copy ALL of them.
> Of course this will make your test database EXACTLY like your live,
> which may not be what you want...

--
Steven Peterson, President
Frontier Productions, Inc.
310 Wesley Drive
Chapel Hill, NC 27516
Tel 919-942-1386; Fax 919-933-2677
peterson_at_frontier-news.com Received on Wed May 20 1998 - 10:37:33 CDT