Re: Copy Oracle DB

From: <dominica_at_secondhat.secondhat.com>
Date: 13 Nov 2001 20:10:15 GMT
Message-ID: <9sr67b$u97$1@secondhat.secondhat.com>

It depend, if your database is less than 5 or 8 gig in size, you could create a new database instance and then "export" and then import it back.

If your database is like 300 Gig+, I don't recommend it. It also depend how many users you have, if you have only less than 10 users, I will do export each user's schema and import it back.

I know you could do a FULL=Y in import too, if you have 200 + users.

Dominica
In article <4dbecf80.0111131155.5ba62efa_at_posting.google.com>, Sirseh Bagh <sbagh_at_fbos.com> wrote:
>Hello everyone.
>
>I am new to the world of Oracle, so please excuse me if my question
>sounds too easy..
>
>I would like to copy an oracle database to another for testing
>reasons. Could you please tell me how to do that in the simplest way
>possible for somebody who just started working with Oracle?
>
>Thank you,
>Sirseh
Received on Tue Nov 13 2001 - 14:10:15 CST