Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Copy Oracle DB
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