Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Best way to 'copy' a database??
The book Oracle Scripts by O'Reilly has a script crdb which will generate a script that will recreate a database's structure with all its tablespaces, data files, redo logs, and rollback segments. See page 113 in
http://www.amazon.com/exec/obidos/ASIN/156592438X/qid%3D943747470/002- 3653208-1959444
Phil Bolduc
North Vancouver, BC Canada
In article <38403D72.4FE67A20_at_yahoo.com>,
Shmooth <shmooth_at_yahoo.com> 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.
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sat Nov 27 1999 - 18:17:19 CST