Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Best way to 'copy' a database??
if you do full imp it will create everything you needed for you,
provided you have the same hardware setup (mount points, space)
Or you can just shut down and do a cold backup/restore
On Sat, 27 Nov 1999 15:22:10 -0500, 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.
>
Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417 AOL: NetComrade ICQ: 11340726 remove NSPAM to emailReceived on Sat Nov 27 1999 - 16:07:56 CST