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: Best way to 'copy' a database??

Re: Best way to 'copy' a database??

From: jclarke <jclarke_at_centroidsys.com>
Date: Sat, 27 Nov 1999 17:36:41 -0500
Message-ID: <38405CF9.BFD7E61D@centroidsys.com>


The "backup control file and copied/FTP'd files" method works well, and usually quicker (depending on your database size).

Shmooth wrote:

> I need to take an Oracle db I have and basically move a copy of it to a
> new machine that has just a base Oracle install. I need new
> tablespaces, schemas, tables, users, permissions, etc. I did, in fact,
> do this already - but it was a major p.i.t.a. Seemed like I had to
> create tablespaces manually, then I had to import each of my schemas
> separately - i.e. I had to run 'imp' once for each schema I had to
> import.
>
> Is there an easier way? Can I get an script generate by Oracle to
> set-up tablespaces, etc.? Then, just run 'imp' once?
>
> Thanks.

--


John Clarke                             (888) 363.2955
Managing Principal Consultant           (248) 593.9935
Centroid Systems, Inc.                  jclarke_at_centroidsys.com
===============================================================




Received on Sat Nov 27 1999 - 16:36:41 CST

Original text of this message

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